Hem > GSOC, Webb > MySQL ta bort alla likadana poster

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 -A

Database 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: 0

mysql> 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>

Categories: GSOC, Webb Taggar: , ,
  1. Inga kommentarer än.
  1. Inga trackbacks än.