- SE LECT MAX(lastclick) as lastclick F ROM `manhua_arctype` W HERE reid NOT IN (0,45) LIMIT 0,1
- se lect a.typename,a.id,a.bookclickm f rom `manhua_arctype` a w here a.reid=’8′ and a.id<>’13587′ order by bookclickm d esc limit 0,10
-
- Se lect a.id,a.typename,a.tuijian,a.typeimg,a.description,a.zuozhe,b.id as reid,b.typename as retypename,c.id as zuozheid F rom `manhua_arctype` a left join `manhua_arctype` b on(b.id=a.reid) left join `manhua_arctype` c on(c.typename=a.zuozhe) WHERE a.reid not in(0,45) and a.booksize<500000 order by a.bookclickm desc limit 0,7
-
- 像上面的两个查询语句，都是从arctype中获取内容，
- 现在用navicat设置的,把where后面的字段单独设置索引了,设置方式是
- 名 栏位 索引类型 索引方式r
- reid reid Normal BTREE
- ID ID NORMAL BTREE
- BOOKCLICKM BOOOKLICKM NORMAL BTREE
- BOOKSIZE BOOKSIZE NORMAL BTREE
复制代码
这样设置对吗? |
