//清空数据,清空表中数据
truncate table user
//删除某字段='XXXX'的数据 delete from login where uid='xxxx'; //删除指定行的数据 delete from login where time>='2016-6-18 0:00:00' order by time limit 10; //删除前面的10条数据
//清空数据,清空表中数据
truncate table user
//删除某字段='XXXX'的数据 delete from login where uid='xxxx'; //删除指定行的数据 delete from login where time>='2016-6-18 0:00:00' order by time limit 10; //删除前面的10条数据