mysql技巧

1、要操作表，怕失误，先备份

create table bak_tablename select * from tablename ;

2、备份表结构，不要里面数据

create table bak_tablename select * from tablename where 1=0;

3、删除重复纪录，保留最小ID

delete from tablename where ID not in(select min(ID) from tablename group by(Name));