how to add new column in table before two column in sql.
Syntax of Alter table:
ALTER TABLE table_name ADD column_name column-definition
Suppose, we have a table named 'employee' having three fields id, name and salary. Now we want to add two new fields dateOfJoining and address. Then using the given query, we can add the new columns to the existing table.
Alter Table employee add (dateOfJoining date, address varchar(20));
For another example, visit the following link:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.