> > >

MySQL MCQs

Consider the following table definition:
CREATE TABLE table1 (
column1 INT,
column2 INT,
column3 INT,
column4 INT
)
Which one of the following is the correct syntax for adding the column, "column2a" after column2, to the table shown above?

ALTER TABLE table1 ADD column2a INT AFTER column2

MODIFY TABLE table1 ADD column2a AFTER column2

INSERT INTO table1 column2a AS INT AFTER column2

ALTER TABLE table1 INSERT column2a INT AFTER column2

CHANGE TABLE table1 INSERT column2a BEFORE column3

Columns are always added after the last column

Answer

Correct Answer: ALTER TABLE table1 ADD column2a INT AFTER column2

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it