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
| Stu_Id |
Stu_Name |
| 1 |
Komal |
| 2 |
Ajay |
| 3 |
Rakesh |
| 4 |
Bhanu |
| 5 |
Santosh |
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
| Stu_Id |
Stu_Name |
Stu_Class |
| 1 |
Komal |
NULL |
| 2 |
Ajay |
NULL |
| 3 |
Rakesh |
NULL |
| 4 |
Bhanu |
NULL |
| 5 |
Santosh |
NULL |

|