mysqlÐÐËøµÄÎÊÌâ

ÒÔϵÚÒ»¸ösession£º
mysql> begin;
Query OK, 0 rows affected

mysql> select id from items where reviewid=37 for update;
+--------+
| id    |
+--------+
| 120041 |
| 120042 |
| 120043 |
| 120044 |
| 120045 |
+--------+
5 rows in set

================================================
ÒÔϵڶþ¸ösession
mysql> begin;
Query OK, 0 rows affected

mysql> update items set getsum=123 where reviewid=36;


ΪʲôµÚ¶þ¸ösessionÔËÐе½ÕâÀï»á±»ËøסÄØ£¬µÚÒ»¸ösessionËøµÄÊÇreviewidΪ37µÄÐа¡£¬reviewidÒѾ­¼ÓÁËË÷Òý£¬Ö±µ½µÚÒ»¸ösessionÔËÐÐcommitºó£¬µÚ¶þ¸ösession²Å³öÏÖÒÔÏÂÌáʾ£º
Query OK, 5 rows affected
Rows matched: 5  Changed: 5  Warnings: 0

---

²¹³ä£ºÕû¸öitems±íµÄ½á¹¹Îª
CREATE TABLE `items` (
  `id` int(11) NOT NULL auto_increment,
  `reviewid` int(11) default '0',
  `query` varchar(100) default NULL,
  `query_cat` varchar(100) default NULL,
  `title` varchar(100) default NULL,
  `url` varchar(100) default NULL,
  `pic_url` varchar(100) default NULL,
  `sell_count` varchar(10) default NULL,
  `credit` varchar(10) default NULL,
  `nick` varchar(30) default NULL,
  `good_rate` varchar(10) default NULL,
  `getsum` int(11) unsigned