- 论坛徽章:
- 0
|
原帖由 cenalulu 于 2009-11-17 11:55 发表 ![]()
explain select iid,title,nick,category_name,pic_path,price,credit from tb_goods using index cid_total
where cid=50010815 order by lmsn desc limit 0,20;
试试看?
explain select iid,title,nick,category_name,pic_path,price,credit from tb_goods using index cid_total where cid=50011986 order by lmsn desc limit 0,20;
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 'using index cid_total where cid=50011986 order by lmsn desc limit 0,20' at line 1 |
|