Mysql 常用命令

1，去掉rigietio_test里的重复行

DELETE n1 FROM rigietio n1, rigietio_test n2 WHERE n1.id > n2.id AND n1.QRcode = n2.QRcode;

2，去掉rigietio_test里id小于40的行

DELETE from rigietio WHERE id BETWEEN 0 AND 40;