SQL Add Column Position

SQL Add Column Position is used to add the column at the specific position. The Alter statement copy the structure of existed table and make a modify a table on the basis of specified Query.

SQL Add Column Position

SQL Add Column Position

     

SQL Add Column Position is used to add the column at the specific position. The Alter statement copy the structure of existed table and make a modify a table on the basis of specified Query.

Understand with Example

The Tutorial illustrates an example from SQL Add Column Position to the existing table 'Stu_Table'.

Create Table Stu_Table

 

 

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

Insert data into 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 table name 'table_name' and add a column at the specific position. The first column specify the position of the column to be come first in table followed by a after column in a table. The Syntax is given as : 

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

SQL Add Colum Query

The SQL Add Column Query add a Stu_Name column followed by Stu_Name in the Table Stu_Table.

Alter Table Stu_Table add Stu_Class int(10) AFTER Stu_Name

View data  Stu_Table

Stu_Id Stu_Name Stu_Class
1 Komal NULL
2 Ajay NULL
3 Rakesh NULL
4 Bhanu NULL
5 Santosh NULL

 

Tutorials

  1. SQL Alter Table Primary Key tutorial
  2. SQL Date, SQL Date Examples
  3. MySql Remove Tutorials
  4. PHP SQL Timestamp
  5. Mysql Date in where clause
  6. MySQL Alter Tutorial, Database MySQL MySQL Crash Tutorial Tutorial
  7. MySQL Examples, Learn MySQL with examples.
  8. MySQL Injection
  9. Mysql Update command
  10. Mysql Trigger After Delete
  11. Mysql Date Part Only
  12. MySQL Append Column
  13. SQL-introduction
  14. Data Normalization
  15. Create a database
  16. The INSERT INTO Statement
  17. The UPDATE Statement
  18. The DELETE Statement
  19. The SELECT statement for SQL
  20. WHERE Statement in SQL
  21. Aggregate Functions
  22. SQL Example, Codes and Tutorials
  23. SQL for Beginner
  24. SQL Introduction
  25. Create Table in Database
  26. Insert Records in Table
  27. Select data from Table in Database
  28. Update Records in Database
  29. Delete a Records in Database
  30. Where Clause in SQL
  31. Drop Table in Database
  32. SQL UNION ALL Operator
  33. SQL Right JOIN
  34. SQL BETWEEN Operator
  35. SQL AND Statement
  36. SQL Add Column Position
  37. SQL Example, Codes and Tutorials
  38. SQL % Wildcards
  39. SQL UNIQUE Constraint
  40. SQL UNION Operator