测试数据:
[img]
[img]http://dl.iteye.com/upload/attachment/0081/6831/496a1956-3785-3dc3-8ddf-9893ace64195.png[/img]
[/img]
一、列的增加:
1,[color=red]alter table 表名 列声明[/color]
增加的列默认在表的最后
[img]
[img]http://dl.iteye.com/upload/attachment/0081/6833/57b25fb5-4f5f-3f03-affd-2e9f28d32638.png[/img]
[/img]
[img]
[img]http://dl.iteye.com/upload/attachment/0081/6835/9a34bb7d-ee20-3e67-807b-55c35858bbf7.png[/img]
[/img]
2,可以用 after来指定新增的列位于哪些列后面
[img]
[img]http://dl.iteye.com/upload/attachment/0081/6837/a3f50afc-0280-379b-aedb-743ae8b7b200.png[/img]
[/img]
3,如果新增的列要放在表的最前面,用 first
[img]
[img]http://dl.iteye.com/upload/attachment/0081/6839/03c68ccd-c620-34a0-a581-2c1ada4da716.png[/img]
[/img]
二、列的修改
[color=red]alter table 表名 change 要修改的列名 列声明[/color]
如表中,name的 varchar长度为10,现在改为20.
[img]
[img]http://dl.iteye.com/upload/attachment/0081/6841/bbd9f904-1517-3f2a-bd3f-9de4a8821904.png[/img]
[/img]
[img]
[img]http://dl.iteye.com/upload/attachment/0081/6843/ca93d080-5851-3861-b52e-594abadfce0b.png[/img]
[/img]
三、列的删除 :
[color=red]alter table 表名 要删除的列名[/color]
例子中,就把 height这一列给删除了,如下:
[img]
[img]http://dl.iteye.com/upload/attachment/0081/6845/b9fa0d15-05c5-3f0a-87f8-7d06f4c4b404.png[/img]
[/img]
[img]
[img]http://dl.iteye.com/upload/attachment/0081/6831/496a1956-3785-3dc3-8ddf-9893ace64195.png[/img]
[/img]
一、列的增加:
1,[color=red]alter table 表名 列声明[/color]
增加的列默认在表的最后
[img]
[img]http://dl.iteye.com/upload/attachment/0081/6833/57b25fb5-4f5f-3f03-affd-2e9f28d32638.png[/img]
[/img]
[img]
[img]http://dl.iteye.com/upload/attachment/0081/6835/9a34bb7d-ee20-3e67-807b-55c35858bbf7.png[/img]
[/img]
2,可以用 after来指定新增的列位于哪些列后面
[img]
[img]http://dl.iteye.com/upload/attachment/0081/6837/a3f50afc-0280-379b-aedb-743ae8b7b200.png[/img]
[/img]
3,如果新增的列要放在表的最前面,用 first
[img]
[img]http://dl.iteye.com/upload/attachment/0081/6839/03c68ccd-c620-34a0-a581-2c1ada4da716.png[/img]
[/img]
二、列的修改
[color=red]alter table 表名 change 要修改的列名 列声明[/color]
如表中,name的 varchar长度为10,现在改为20.
[img]
[img]http://dl.iteye.com/upload/attachment/0081/6841/bbd9f904-1517-3f2a-bd3f-9de4a8821904.png[/img]
[/img]
[img]
[img]http://dl.iteye.com/upload/attachment/0081/6843/ca93d080-5851-3861-b52e-594abadfce0b.png[/img]
[/img]
三、列的删除 :
[color=red]alter table 表名 要删除的列名[/color]
例子中,就把 height这一列给删除了,如下:
[img]
[img]http://dl.iteye.com/upload/attachment/0081/6845/b9fa0d15-05c5-3f0a-87f8-7d06f4c4b404.png[/img]
[/img]