Home >Database >Mysql Tutorial >Mysql数据进行并发锁定_MySQL

Mysql数据进行并发锁定_MySQL

WBOY
WBOYOriginal
2016-06-01 13:55:291068browse

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;

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn