How do you add a new column to an existing table in MySQL?

Adding a new column in MySQL can be achieved using the ALTER TABLE statement. Specifically, follow these steps:

1. Identify the table name to modify: First, determine the name of the table you intend to modify.
2. Specify the name and data type for the new column: Next, define the name and data type for the new column (e.g., INT, VARCHAR, DATE, etc.).
3. Execute the ALTER TABLE statement: Finally, run the ALTER TABLE statement to add the new column.

Here is a specific example:

Suppose we have a table named employees, and we want to add a column named birthdate with the data type DATE. We can use the following SQL statement to add this new column:

sql
ALTER TABLE employees
ADD COLUMN birthdate DATE;

This statement adds a new column birthdate to the employees table with the data type DATE.

Key Considerations:

• Default value: If you want the new column to have a default value, specify it in the statement, for example:

  sql
  ALTER TABLE employees
  ADD COLUMN start_date DATE DEFAULT '2021-01-01';

• Position: You can also specify the position where the new column should be added (e.g., after a specific column), for example:

  sql
  ALTER TABLE employees
  ADD COLUMN department_id INT AFTER department_name;

By following these steps and considerations, you can effectively manage and adjust the structure of your MySQL database tables to meet evolving business requirements.