mysql修改表数据加一_mysql 修改数据表（alter）[转]

为了方便后面的说明,先创建一个表,创建语句如下:

Create Table member(

id Int(3),

name Varchar(8),

pass Varchar(25)

);

1.向表member中增加一个新列email,MySQL语句如下:

Alter Table member Add email Varchar(50) Not Null;

Describe member;

+-------+-------------+------+-----+---------+-------+

| Field | Type        | Null | Key | Default | Extra |

+-------+-------------+------+-----+---------+-------+

| id    | int(3)      | YES  |     | NULL    |       |

| name  | varchar(8)  | YES  |     | NULL    |       |

| pass  | varchar(8)  | YES  |     | NULL    |       |

| email | varchar(50) | NO   |     | NULL    |       |

+-------+-------------+------+-----+---------+-------+

4 rows in set (0.00 sec)

2.向表member中添加一个新的主键id,MySQL语句如下:

Alter Table member Add Primary Key(id);

Describe member;

+-------+-------------+------+-----+---------+-------+

| Field | Type        | Null | Key | Default | Extra |

+-------+-------------+------+-----+---------+-------+

| id    | int(3)