修改table

一、添加：

<pre name="code" class="sql">mysql> desc t1;
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id    | int(11) | YES  |     | NULL    |       |
+-------+---------+------+-----+---------+-------+
1 row in set (0.04 sec)

1）添加一个字段：

mysql> desc t1;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id    | int(11)     | YES  |     | NULL    |       |
| name  | varchar(20) | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+

<span style="font-family: Arial, Helvetica, sans-serif;"><strong>2）在某字段之后添加(只有在...之后添加，没有在...之前添加)：</strong></span>

alter table t1 add age int after id

3）在首行添加

alter table t1 add class varchar(20) in first

</pre><pre name="code" class="sql">

</pre><pre name="code" class="sql">

</pre><pre name="code" class="sql">

</pre><pre name="code" class="sql">

</pre><pre name="code" class="sql">

</pre><pre name="code" class="sql">

</pre><pre name="code" class="sql">

</pre><pre name="code" class="sql">

</pre><p></p><pre>

4）添加主键

alter table t1 add primary key(id)

5)添加外键(t1中的sid指向student的主键sno)

alter table t1 add foreign key(sid) references student(sno);

6)对某一列修改或添加默认值

alter table t1 alter id set default '100'

7)修改某一个字段change

alter table t1 change name name_2  char(10)

8）修改某一个字段modify

alter table t1  modify name_2 char(50)

9）删除主键

alter table t1 drop primary key

10)修改表的类型

alter table t1 engine innodb

11)修改表的名字

alter table t1 rename as t2

示例：

alter table test modify id int not null auto_inrement primary key(id)