MySQL添加和刪除欄位

標籤：

查詢表的欄位類型：

 

mysql> desc t_template_title;+----------------+--------------+------+-----+---------+-------+| Field          | Type         | Null | Key | Default | Extra |+----------------+--------------+------+-----+---------+-------+| id             | int(11)      | NO   |     | 0       |       || effective_time | int(11)      | NO   |     | 0       |       || props          | varchar(128) | NO   |     |         |       || props_passive  | varchar(128) | NO   |     |         |       || buffs          | varchar(128) | NO   |     |         |       || name           | varchar(64)  | NO   |     |         |       || resource_type  | int(11)      | NO   |     | 0       |       || resource_id    | int(11)      | NO   |     | 0       |       || pic_width      | int(11)      | NO   |     | 0       |       || pic_height     | int(11)      | NO   |     | 0       |       || descript       | varchar(256) | NO   |     |         |       || agent          | smallint(6)  | NO   |     | 0       |       || type           | tinyint(4)   | NO   |     | 0       |       || order          | int(4)       | NO   |     | 0       |       |+----------------+--------------+------+-----+---------+-------+

　　

 

添加欄位：

alter table t_template_title add props_passive VARCHAR(128) NOT NULL default ‘‘ after props;

　

 

刪除欄位：

mysql> alter table t_template_title drop props_passive;

　　

MySQL添加和刪除欄位