在MySQL中,把TEST表的ID列设置为主键,并在NAME字段上创建普通索引。
A答案如下所示:
ALTER TABLE TEST CHANGE ID ID INT PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE TEST ADD INDEX INDEX_NAME(NAME);
查看索引:
mysql> DESC TEST;
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| AGE | tinyint(4) | YES | | NULL | |
| name | varchar(20) | NO | MUL | NULL | |
+-------+-------------+------+-----+---------+----------------+