Shulou(Shulou.com)06/02 Report--

This article introduces the knowledge of "what is the method of removing duplicate data in php database". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Php database to remove duplicate data methods: 1, open the corresponding PHP file; 2, connect to the database; 3, through the native sql statement "Db::execute ('DELETE from data WHERE (phone) in..." to remove duplicate data.

This article operating environment: Windows7 system, PHP7.1 version, DELL G3 computer

How does the php database remove duplicate data?

When developing a project, there is often duplicate data. How to remove the duplicate data?

Today, I'd like to share with you a simple method.

Normally, no matter using framework development or native php, there are few methods to repeat them. Basically, we need to embed the native sql ourselves. Let's give you the source code directly.

/ / Native sql deduplication leaves only one res = Db::execute ('DELETE from data WHERE (phone) in (SELECT phone from (SELECT phone FROM data GROUP BY phone HAVING COUNT (phone) > 1) S1) AND id NOT in (SELECT id from (SELECT id FROM data GROUP BY phone HAVING COUNT (phone) > 1) S2)'); if ($res) {$this- > success ('deduplicated successfully', 'index/maamiya');} else {$this- > error (' there are no duplicates') } this is the end of the content of "what is the method of removing duplicate data in php database". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.