.jpg)
Mysql - Delete duplicate rows based on column value.
Mysql - Delete duplicate rows based on column value by below query.
CREATE TABLE temp_name AS SELECT * FROM tab WHERE 1 GROUP BY colname;
DROP TABLE tab;
RENAME TABLE temp_name TO tab;
Mar 9, 2013
Mysql - Delete duplicate rows based on column value
Mysql - Delete duplicate rows based on column value.
Mysql - Delete duplicate rows based on column value by below query.
CREATE TABLE temp_name AS SELECT * FROM tab WHERE 1 GROUP BY colname;
DROP TABLE tab;
RENAME TABLE temp_name TO tab;
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment