How to add a column to an existing table in MySQL?

ALTER TABLE students ADD COLUMN email VARCHAR(100);
ALTER TABLE students ADD COLUMN status VARCHAR(10) DEFAULT 'active' AFTER name;

Existing rows get NULL (or the default value) in the new column. To remove it use ALTER TABLE students DROP COLUMN email;. See MySQL ALTER TABLE.

• Previous Interview Question

---

Tutorials
No Content Found.

Exercises & Assignments
No Content Found.

Interview Questions & Answers
No Content Found.