Write A Query To Insert A New Column(new_col Int) Into A Hiev Table (

1.	Write A Query To Insert A New Column(new_col Int) Into A Hiev Table (htab) At A Position Before An Existing Column (x_col)
Answer» ALTER TABLE table_name CHANGE COLUMN new_col INT BEFORE x_col ALTER TABLE table_name CHANGE COLUMN new_col INT BEFORE x_col

Write A Query To Insert A New Column(new_col Int) Into A Hiev Table (htab) At A Position Before An Existing Column (x_col)

Answer»

ALTER TABLE table_name
CHANGE COLUMN new_col INT
BEFORE x_col