Add a new field (column) to an existing table in the MySQL database

--Preface: Recently, because the project needs to use Mysql,mysql never used, although this belongs to small and medium-sized enterprises, network companies use, the main point is that it cross-platform type, and the purchase cost is lower, up to open source. So it occupies most of the market share.

ALTER table ' database name '. ' Table name ' ADD COLUMN ' ProcID ' VARCHAR (6) DEFAULT ' after ' ppidchanged ';

--in MySQL, if the table name, database name, column name, when you add, modify, update, you need to use the ESC keyboard accent, before you can add, the corresponding column name or update changes.

This is purely a record of what you need to use in your project.

Add a new field (column) to an existing table in the MySQL database