Question

Which MySQL command helps to add a primary key constraint to any table that has already been created? 

Options

• UPDATE

• INSERT INTO

• ALTER TABLE

• ORDER BY

Answer 1

ALTER TABLE

Explanation:

The ALTER TABLE statement and the ADD CONSTRAINT clause can be used in SQL to add a primary key. The syntax is as follows: ALTER TABLE table_name.