MYSQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the ALTER TABLE statement in MySQL?

How do you add a new column to an existing table using the ALTER TABLE statement?

How do you rename a column in an existing table using the ALTER TABLE statement?

How do you remove a column from an existing table using the ALTER TABLE statement?

How can you change the data type of a column in an existing table using the ALTER TABLE statement?

How do you add a primary key constraint to an existing table using the ALTER TABLE statement?

How do you add a foreign key constraint to an existing table using the ALTER TABLE statement?

How can you add an index to an existing table using the ALTER TABLE statement?

How do you change the default value of a column in an existing table using the ALTER TABLE statement?

Describe how to partition an existing table using the ALTER TABLE statement.