我试了一下二楼的那句,但是出现了这样的错误: ERROR 1248 (42000): Every derived table must have its own alias 后来才来我又用如下语句才行: mysql>create temporary table temp (select * from tbname order by fieldname limit 100); mysql>select * from temp order by rand() limit 5;说明:第一句是创建了一个临时表,并且复制了tbname按最新产品前100条记录。 我用的是4.1
ERROR 1248 (42000): Every derived table must have its own alias
后来才来我又用如下语句才行:
mysql>create temporary table temp (select * from tbname order by fieldname limit 100);
mysql>select * from temp order by rand() limit 5;说明:第一句是创建了一个临时表,并且复制了tbname按最新产品前100条记录。
我用的是4.1