Query the field type of the table:
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 | |+----------------+--------------+------+-----+---------+-------+
To add a field:
ALTER TABLE T_template_title add props_passive VARCHAR (+) not NULL default "after props;
To delete a field:
mysql> ALTER TABLE t_template_title drop props_passive;
MySQL Add and remove fields