Add new fields (columns) to existing tables in the Mysql database _mysql

Copy Code code as follows:

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

In MySQL, if the table name, database name, column name, as you add, modify, update, you need to use the ESC keyboard accent, you can add, the corresponding column name or update changes.

Of course now most are using phpMyAdmin or MySQL graphical operation tools, more methods, such as temporary use, or no graphical interface method. You can use the above graphic chemical tool operation.

Several software are recommended below:

MySQL Graphics management tools navicat 8.2 Chinese free Edition
Sql-front v4.2 Build 2.7 Cracked special edition