创建表
CREATETABLElogin_user(
`id`SMALLINT(10)NOTNULLAUTO_INCREMENTPRIMARYKEY,
`username`CHAR(8)NOTNULL,
`password`CHAR(4)NOTNULL,
`level`TINYINT(1)DEFAULT0,
`last_login`CHAR(15)NOTNULL,
INDEX(username,PASSWORD,last_login))ENGINE=INNODB;
查看索引
SHOWINDEXFROM