Skip to main content

Create column after a column in existing table using query in MySQL

You can create a column in an existing table after a particular column using MySQL. You can use an alter table statement in MySQL to create a column after a specific column.

  • Create column after a specific column using Mysql query

    //Syntax :
    ALTER TABLE table_name ADD [COLUMN] column_name column_definition AFTER existing_column;
    // MySQL Query
    ALTER TABLE contacts ADD full_name varchar(40) NOT NULL AFTER id;

    The Query is used to create a full_name column with varchar and NOT NULL definition after id column in the contacts table.

  • Back to code snippet queries related sql