56,677
社区成员
发帖
与我相关
我的任务
分享
SELECT VERSION(); -- 5.0.22-community-nt
SET @@autocommit = 0;
SELECT @@autocommit; -- 0
CREATE TABLE t(
id INT,
NAME VARCHAR(50),
address VARCHAR(100),
PRIMARY KEY(id,NAME)
) ENGINE =INNODB;
INSERT INTO t
(id,NAME,address)
VALUES
(1,'yubowei','weifang'),
(2,'sam','qingdao');
COMMIT;
UPDATE t
SET address = 'weifang'
WHERE id = 1
AND NAME = 'yubowei';
SELECT ROW_COUNT(); -- -1
UPDATE t
SET address = 'beijing'
WHERE id = 1
AND NAME = 'yubowei';
SELECT ROW_COUNT(); -- -1
mysql> UPDATE t
-> SET address = 'beijing111'
-> WHERE id = 1
-> AND NAME = 'yubowei';
Query OK, 1 row affected (0.30 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql>
mysql> SELECT ROW_COUNT();
+-------------+
| ROW_COUNT() |
+-------------+
| 1 |
+-------------+
1 row in set (0.00 sec)
mysql>