56,685
社区成员
发帖
与我相关
我的任务
分享
mysql> CREATE TEMPORARY TABLE TMP(A int);
ERROR 1046 (3D000): No database selected
mysql> use mydb;
Database changed
mysql> CREATE TEMPORARY TABLE TMP(A int);
Query OK, 0 rows affected (0.20 sec)
mysql> insert into TMp values(1);
Query OK, 1 row affected (0.06 sec)
mysql> select * from tmp;
+------+
| A |
+------+
| 1 |
+------+
1 row in set (0.00 sec)
mysql> exit
Bye
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
D:\mysql6\bin>mysqldump -uroot -p123 mydb tmp>1.sql
mysqldump: Couldn't find table: "tmp"
D:\mysql6\bin>