1、查询表结构:
mysql> desc grades;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| name | varchar(50) | YES | | NULL | |
| age | int(11) | YES | | NULL | |
| ywscore | int(11) | YES | | NULL | |
| sxscore | int(11) | YES | | NULL | |
| yyscore | int(11) | YES | | NULL | |
| count | int(100) | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
2、设置主键:
mysql> ALTER TABLE grades ADD PRIMARY KEY (name);
Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0
3、查看设置完后的表结构:
mysql> desc grades;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| name | varchar(50) | NO | PRI | | |
| age | int(11) | YES | | NULL | |
| ywscore | int(11) | YES | | NULL | |
| sxscore | int(11) | YES | | NULL | |
| yyscore | int(11) | YES | | NULL | |
| count | int(100) | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)