-
Improvement to article: Deleting Duplicate Rows in a MySQL Database
A reader has just pointed out an improvement to my most recent article
On page 2, you can of course use:
CREATE TEMPORARY TABLE bad_temp AS SELECT DISTINCT * FROM bad_table
instead of:
CREATE TEMPORARY TABLE
bad_temp(id INT,name VARCHAR(20))
TYPE=HEAP;
INSERT INTO bad_temp(id,name) SELECT DISTINCT id,name FROM bad_table;
saving yourself doing it in two steps.
Thanks to P-A Fredriksson. Hopefully the changes will reflect on the site soon.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|