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

Add column after an existing column in MYSQL

About the Author

SRINI S

A passionate blogger. Love to share solutions and best practices on wordpress hosting, issues and fixes, excel VBA macros and other apps