增加索引:
#插入
alter table table\_name add index index\_name (`field1`, `field2`, `field3`)
#建表时
KEY `username_passwd_status` (`username`,`passwd`,`status`)
#插入
alter table table\_name add index index\_name (`field1`, `field2`, `field3`)
#建表时
KEY `username_passwd_status` (`username`,`passwd`,`status`)
Copyright © 2016 yjiang's cake