How do I alter a table in MySQL

To alter a table in MySQL, you can use the ALTER TABLE statement. This statement allows you to make changes such as adding, deleting, or modifying columns in an existing table. Below are some examples of how to use this command effectively.

Example of Altering a Table


        -- Adding a new column
        ALTER TABLE employees 
        ADD COLUMN birthdate DATE;

        -- Modifying an existing column
        ALTER TABLE employees 
        MODIFY COLUMN last_name VARCHAR(100);

        -- Dropping a column
        ALTER TABLE employees 
        DROP COLUMN middle_name;