修改mysql数据库表结构的方法：1、查看表结构；2、添加列；3、删除列，代码为【mysql> alter table student drop column birthday】；4、修改列，代码为【mysql> alter table】。

修改mysql数据库表结构的方法：

1、查看表结构

mysql>showcreatetablestudent;+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+|Table|CreateTable|+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+|student|CREATETABLE`student`(`ID`int(11)NOTNULLAUTO_INCREMENT,`NAME`varchar(20)NOTNULL,`AGE`int(11)NOTNULL,PRIMARYKEY(`ID`))ENGINE=InnoDBAUTO_INCREMENT=13DEFAULTCHARSET=utf8|+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+1rowinset(0.09sec)

2、添加列

mysql>altertablestudentaddcolumnbirthdaydatetime;QueryOK,0rowsaffected(2.06sec)Records:0Duplicates:0Warnings:0

3、删除列

mysql>altertablestudentdropcolumnbirthday;QueryOK,0rowsaffected(0.80sec)Records:0Duplicates:0Warnings:0

4、修改列

--1.修改列的类型mysql>altertablestudentmodifyageintnotnull;QueryOK,0rowsaffected(0.09sec)Records:0Duplicates:0Warnings:0--2.修改列的名称mysql>altertablestudentchangecolumnnamesnamevarchar(20);QueryOK,0rowsaffected(1.31sec)Records:0Duplicates:0Warnings:0