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

CopyCodeThe Code is as follows: alter table 'database name'. 'table name' add column 'procid' varchar (6) default ''after 'ppidchanged ';

-- In MySQL, if the table name, database name, and column name are used, you must use the accent symbol on the ESC keyboard to add, modify, and update Tables, corresponding column name or update and modify.

Of course, most of them are currently using phpMyAdmin or MySQL graphical operation tools, more methods, this is temporary use, or there is no graphical interface method. You can use the preceding graphical tools.

The following software is recommended:

MySQL graphic management tool navicat 8.2 free Chinese Version
SQL-front v4.2 build 2.7 special edition for cracking