MySQLPHPAdmin中,得到的错误是You have an error in your SQL syntax; check the manual that corresponds to your MySQLserver version for the right syntax to use near '1update page SET RegionId = 1 WHERE (RegionId = -1$sql = "update page SET RegionId = 2 WHERE (RegionId = -
get any 2 tickets that are available:from tickets LIMIT 2 FOR UPDATE;
--(...psuedo code: if 2 records were returned, set status to 'reserved' and update other tables ,--otherwise rollback as all tickets could not be fulf