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