SQL Add Column Position

The Tutorial helps you to understand an example from 'SQL  Add Column Position' in Mysql. To understand and grasp the example we simply create a table 'Stu_Table' with required fieldnames and datatypes respectively.

Understand with Example

The Tutorial illustrate an example from 'SQL Add Column Position'.To understand and grasp this example we create a table 'Stu_Table' with required fieldname and datatypes respectively. 

Create Table Stu_Table

create table Stu_Table(Stu_Id integer(2), Stu_Name varchar(15));

Insert data into Stu_Table

The insert into adds the records or rows to the table 'Stu_Table'.

insert into Stu_Table values(1,'Komal');
insert into Stu_Table values(2,'Ajay');
insert into Stu_Table values(3,'Rakesh');
insert into Stu_Table values(4,'Bhanu');
insert into Stu_Table values(5,'Santosh);

 Stu_Table

SQL Add Column Syntax

The Alter Table is used to modify the definition of table and add the columns to the table in order.

ALTER TABLE table_name
ADD column_name column-definition [ FIRST | AFTER col_name ]

SQL Add Column Query

The below Query is used to redefine the table 'Stu_Table' and add the column Stu_Name followed by the sequence Stu_Class.

Alter Table Stu_Table add Stu_Class int(10) AFTER Stu_Name

Stu_Table