建表过程-列名&列类型&修改表小试题C

#新增数据

INSERT INTO goods VALUES(10,'豆豆','男',85.2,'2016-12-14',5000.36,'2016-12-14 12:05:06','高')

INSERT INTO goods VALUES(11,'小小','女',86.2,'2016-12-13',5000.36,'2016-12-13 11:05:06','高');

INSERT INTO goods VALUES(12,'笑笑','女',84.2,'2015-12-14',5000.36,'2015-12-14 12:05:06','高');

INSERT INTO goods VALUES(13,'徐小刀','女',88.2,'2014-12-14',5000.36,'2014-12-14 12:05:06','高');

#在表中增加列

ALTER TABLE goods ADD beizhu VARCHAR(100) 

#新增一列到指定的某一列后面

ALTER TABLE goods ADD xinqing VARCHAR(100) AFTER Personal 

#最前面加上一列 

ALTER TABLE goods ADD test VARCHAR(100) FIRST; 

#修改表名

 RENAME TABLE goods TO gooda; 

 #在表中增加列

ALTER TABLE gooda ADD id VARCHAR(100)

#删除一列

 ALTER TABLE gooda DROP beizhu

 #修改列类型

ALTER TABLE gooda MODIFY gaodu DECIMAL(2,2) 

#修改列名

ALTER TABLE gooda CHANGE  id rezheng DECIMAL(2,2)

 

 

转载于:https://www.cnblogs.com/AngelKing1111/p/6184726.html