Mysql數據進行並發鎖定

MySQL> LOCK TABLES real_table WRITE, insert_table WRITE;
MySQL> insert into real_table select * from insert_table;
MySQL> delete from insert_table;
MySQL> UNLOCK TABLES;