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

Editor to share with you the method of mysql to remove repeated queries, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Mysql method to remove repeated queries: 1, use distinct, code is [select distinct name from a where statesign=0]; 2, use group by, code is [statesign=0 group by.].

Mysql's method to remove duplicate queries:

1: use distinct

Select distinct name from a where statesign=0

Query the name field in table a to remove duplicate records

2: use group by

Select name from a where statesign=0 group by name

Query the name field in table a, group, and remove duplicate records

These are all the contents of mysql's method of removing repeated queries. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.