数据库锁

解除表锁：

show processlist;

找到锁进程，kill id ;

 

秒杀数据库事务锁：

set autocommit=0;
begin work;
set @AGE = (select age from t_user where id=1 for update);
select 1;
select SLEEP(3),@AGE;
update t_user set age = @AGE +1 where id=1;

/*rollback;*/

commit;