mysql中lock_mysql lock 锁表

$sql1="LOCKTABLES`tests1`,`tests`READ";$query1=mysql_query($sql1);$sql2="select*from`tests`where`state`='0'orderbyidasclimit0,1";$query2=mysql_query($sql2);$rs2=mysql_fet...

$sql1 = "LOCK TABLES `tests1`,`tests` READ";

$query1=mysql_query($sql1);

$sql2="select * from `tests` where `state`='0' order by id asc limit 0,1";

$query2=mysql_query($sql2);

$rs2=mysql_fetch_array($query2);

$sql5 = "update `tests` set `state`='1' where `id`='".$rs2['id']."'";

$query5=mysql_query($sql5);

$sql3="select * from `tests1` where `state`='0' order by id asc limit 0,1";

$query3=mysql_query($sql3);

$rs3=mysql_fetch_array($query3);

$sql6 = "update `tests1` set `state`='1' where `id`='".$rs3['id']."'";

$query6=mysql_query($sql6);

$sql4="insert into `tests2` (`name1`,`name2`,`time`) value('".$rs2['name']."','".$rs3['name']."','".time()."')";

$query4=mysql_query($sql4);

/*$fp = fopen("log.txt","a");//创建缓存

@fwrite($fp,$rs2['name']." ".$rs3['name']."\r\n");//写入文件

@fclose($fp);

sleep(1);*/

$sql7 = "UNLOCK TABLES";

$query=mysql_query($sql7);

如果短时间内执行多次的话 会查出重复的。。

展开