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

Related Tags for SQL Add Column Position:
sql,  mysql,  c,  table,  data,  asp,  ui,  datatypes,  io,  types,  help,  type,  column,  tutorial,  field,  name,  ria,  position,  create,  tab,  ie,  example,  add,  with,  to,  datatype,  exam,  require,  pos,  names,  ld,  e,  it,  pe,  im,  from,  in,  as,  sta,  m,  ps,  os,  osi,  dd,  osi,  os,  ad,  es,  spec,  me,  tor,  umn,  xa,  xamp,  s,  respect,  sp,  esp,  col,  at,  ply,  ras,  my,  ir,  iv,  mpl,  dn,  ea,  and,  sim,  tutor,  s,  s,  ri,  th,  st,  ab,  abl,  dna,  lum,  grasp,  ple,  pl,  nd,  on,  om,  ol,  o

More Tutorials from this section

• MySQL Add Column
• Mysql Table
• MySQL Create Table
• MySQL PHP Insert
• MySQL PHP Query delete
• MySQL PHP Search
• Mysql PHP Select
• Mysql PHP Where
• PHP SQL Fetch
• PHP SQL Insert Statement
• PHP SQL Insert
• PHP SQL Insertion
• Mysql Add Column Default Value
• Mysql Add Column Number
• SQL Add Column Int
• SQL Add Column Position
• SQL All Column Names
• SQL All Tables
• PHP SQL Rows
• PHP SQL Search

Ask Questions?    Discuss: SQL Add Column Position  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):