MySQL ta bort alla likadana poster
För att enkelt ta bort likadana poster i MySQL följ guiden nedan:
mysql> use XXX;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -ADatabase changed
mysql> create table ny_posts AS select * from posts where 1 group by post_title;
Query OK, 1674 rows affected (0.11 sec)
Records: 1674 Duplicates: 0 Warnings: 0mysql> drop table posts;
Query OK, 0 rows affected (0.01 sec)mysql> rename table ny_posts to posts;
Query OK, 0 rows affected (0.00 sec)mysql>
Kommentarer