How to delete duplicate data method by mysql
The following mainly brings you mysql how to delete duplicate data method, I hope these words can bring you practical use, this is also the main purpose of this article I edit mysql how to delete duplicate data method. All right, don't talk too much nonsense, let's just read the following.
Delete from student where stId in (select stId from (select min (stId) stId from student group by stNo having count (stNo) > 1) temp_user)
If you have more than one duplicate statement, you can repeat the above statement until there is no result.
For the above about mysql how to delete duplicate data method, we do not think it is very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like it.
