MySql锁表解表

show OPEN TABLES where In_use > 0;SHOW PROCESSLIST查看数据库中表的状态，是否被锁；kill id   //杀掉被锁的表===================================================set autocommit=0;select * from t1  where uid='xxxx' for update    //在有索引（例如uid）的情况下是行锁，否则是表锁insert into t1 values(1,'xxxxx');commit;=====================================================lock tables t1 write|read;insert into t1 values(2,'xxxxx'); //只有insertunlock tables;