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 to allright_flash() :好像不行啊~~~
create temporary table temp select name from test; 可行~~~
mysql_query($sql) OR die(”query false!”);
mysql> create temporary table tmp_table (
-> name varchar (10) not null
-> ) ;
Query OK, 0 rows affected (0.11 sec)mysql> desc tmp_table ;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| name | varchar(10) | NO | | | |
+-------+-------------+------+-----+---------+-------+
1 row in set (0.05 sec)mysql> insert into tmp_table
-> values ('yeah') ;
Query OK, 1 row affected (0.05 sec)mysql> select *
-> from tmp_table ;
+------+
| name |
+------+
| yeah |
+------+
1 row in set (0.01 sec)
你的命令写对了没啊?
但是不知道有没试过在程序中执行
牵扯到session问题就不是那么简单了~~~不过 allright_flash() 的直接将select出来的数据放到临时表中,我倒没试过先试试回头贴结果~~
+----------+
| 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
to allright_flash() :好像不行啊~~~
可行~~~
版本问题吧
研究你的mysql的说明文档,看是否支持临时表