如何修改mysql數據庫表結構

修改mysql數據庫表結構的方法:1、查看表結構;2、添加列;3、刪除列,代碼為【mysql> alter table student drop column birthday】;4、修改列,代碼為【mysql> alter table】。

如何修改mysql數據庫表結構

本教程操作環境:windows7系統、mysql 8.0.22版、thinkpad t480電腦。

相關免費學習推薦:mysql數據庫(視頻)

修改mysql數據庫表結構的方法:

1、查看表結構

mysql>?show?create?table?student; +---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ |?Table???|?Create?Table??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????| +---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ |?student?|?CREATE?TABLE?`student`?( ??`ID`?int(11)?NOT?NULL?AUTO_INCREMENT, ??`NAME`?varchar(20)?NOT?NULL, ??`AGE`?int(11)?NOT?NULL, ??PRIMARY?KEY?(`ID`) )?ENGINE=InnoDB?AUTO_INCREMENT=13?DEFAULT?CHARSET=utf8?| +---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1?row?in?set?(0.09?sec)

2、添加列

mysql>?alter?table?student?add?column?birthday?datetime; Query?OK,?0?rows?affected?(2.06?sec) Records:?0??Duplicates:?0??Warnings:?0

3、刪除列

mysql>?alter?table?student?drop?column?birthday; Query?OK,?0?rows?affected?(0.80?sec) Records:?0??Duplicates:?0??Warnings:?0

4、修改列

--1.修改列的類型 mysql>?alter?table?student?modify?age?int?not?null; Query?OK,?0?rows?affected?(0.09?sec) Records:?0??Duplicates:?0??Warnings:?0 ? --2.修改列的名稱 mysql>?alter?table?student?change?column?name?sname?varchar(20); Query?OK,?0?rows?affected?(1.31?sec) Records:?0??Duplicates:?0??Warnings:?0

相關免費學習推薦:mysql數據庫

以上就是如何修改

? 版權聲明
THE END
喜歡就支持一下吧
點贊8 分享