的确如此Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.0-alpha-max-nt-logType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> use mysql
Database changed
mysql> CREATE TEMPORARY TABLE `tmp` SELECT `Host`,`User`,`Password` FROM `user`;Query OK, 3 rows affected (0.22 sec)
Records: 3 Duplicates: 0 Warnings: 0mysql> SELECT * FROM `tmp`;
+-----------+-------+----------+
| Host | User | Password |
+-----------+-------+----------+
| localhost | root | |
| % | root2 | |
| localhost | | |
+-----------+-------+----------+
3 rows in set (0.00 sec)mysql>
Your MySQL connection id is 2 to server version: 4.1.0-alpha-max-nt-logType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> use mysql
Database changed
mysql> CREATE TEMPORARY TABLE `tmp` SELECT `Host`,`User`,`Password` FROM `user`;Query OK, 3 rows affected (0.22 sec)
Records: 3 Duplicates: 0 Warnings: 0mysql> SELECT * FROM `tmp`;
+-----------+-------+----------+
| Host | User | Password |
+-----------+-------+----------+
| localhost | root | |
| % | root2 | |
| localhost | | |
+-----------+-------+----------+
3 rows in set (0.00 sec)mysql>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货