mysql> select * from test;
+----------+
| name |
+----------+
| f |
| e |
| ef |
| efs |
| efsf |
| efsfa |
| efsfae |
| efsfafe |
| efsfaefe |
+----------+
9 rows in set (0.22 sec)
mysql> create temporary table select name from test;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'selec
t name from test' at line 1