摘要:
转载自:http://pcedu.pconline.com.cn/empolder/db/mysql/0509/697012_10.htmlCursor Characteristics 游标的特性 摘要: READ ONLY只读属性 NOT SCROLLABLE顺序读取 ASENSITIVE敏感 在5.0版的MySQL中,你只可以从游标中取值,不能对其进行更新。因为游标是(READONLY)只读的。你可以这样做:FETCH cursor1 INTO variable1;UPDATE t1 SET column1 = 'value1' WHERE CURRENT OF curso 阅读全文
posted @ 2011-08-28 14:26
DavidYanXW
阅读(318)
评论(0)
推荐(0)
摘要:
转载自:http://www.itpub.net/thread-1212446-1-1.htmlmysql> CREATE TABLE TEST1(ID INT);Query OK, 0 rows affected (0.00 sec)mysql> INSERT INTO TEST1 VALUES(1),(2),(3),(4),(5);Query OK, 5 rows affected (0.00 sec)Records: 5Duplicates: 0Warnings: 0mysql> CREATE TABLE TEST2(ID INT);Query OK, 0 rows a 阅读全文
posted @ 2011-08-28 14:25
DavidYanXW
阅读(149)
评论(0)
推荐(0)
浙公网安备 33010602011771号