Add column after an existing column in MYSQL

In this tutorial, we show you how to add a column after or before of an existing column in MYSQL.

Using ALTER and ADD commands in MYSQL

Syntax is given below

ALTER TABLE table_name
ADD COLUMN new_column new_column_type AFTER existing_column;

Example: Adding new column after an existing column