Add a column to the MySQL table

Adding a column to MySQL if you want to add a column to an already-built table, you can use:

ALTER TABLE table_name ADD column new_column_name varchar () not NULL;

This statement adds a new column to the existing table, which is the last column in the table. If you want to add a column that you specify, you can use:

ALTER TABLE table_name ADD column new_column_name varchar () not NULL after column_name;

The above command means adding a new column after a column. If you want to add to the first column, you can use:

ALTER TABLE table_name ADD column new_column_name varchar () not NULL first;

Example

The first table is like this.

The table that executed the SQL statement

The other ways to add new columns are the same

Add a column to the MySQL table