1. 当进程死锁
mysql -uroot -p
show open tables where in_use>0;
show processlist;
kill <id>;
2. MySQL把数据表清空后让自增主键从0开始
truncate TABLE <your table>;
1. 当进程死锁
mysql -uroot -p
show open tables where in_use>0;
show processlist;
kill <id>;
2. MySQL把数据表清空后让自增主键从0开始
truncate TABLE <your table>;