mysql> use mylibrary
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> set @a=0;
Query OK, 0 rows affected (0.00 sec)
mysql> select count(*) into @a from titles;
Query OK, 1 row affected (0.05 sec)
mysql> select @a;
+------+
| @a |
+------+
| 67 |
+------+
1 row in set (0.00 sec)
mysql> select count(*) from titles;
+----------+
| count(*) |
+----------+
| 67 |
+----------+
1 row in set (0.00 sec)
mysql>
阅读(678) | 评论(0) | 转发(0) |
