mysql 修改表结构操作
mysql> desc passwd ; +----------+-------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+----------------+
|> | date | year(4) | YES| | NULL | |
| username | char(30) | NO | MUL | NULL | |
| pass | char(1) | NO | | NULL | |
| uid | int(5) | NO | | NULL | |
| gid | int(5) | NO | | NULL | |
| common | varchar(50) | YES| | NULL | |
| homedir| char(50) | YES| | NULL | |
| shell | char(50) | NO | | NULL | |
| QQ | int(16) | YES| | NULL | |
+----------+-------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)
页:
[1]