Need to expand your database schema? The `ALTER TABLE ADD COLUMN` statement is your go-to tool! It's how you add new fields to existing tables, allowing you to store more data without rebuilding your entire database.
The basic syntax is straightforward:
```sql
ALTER TABLE table_name
ADD COLUMN column_name data_type;
```
For example, to add an 'email' column (of type VARCHAR with a maximum length of 255) to a 'users' table, you'd use:
```sql
ALTER TABLE users
ADD COLUMN email VARCHAR(255);
```
Don't forget to choose the right data type for your new column! You can also specify constraints like `NOT NULL` or `DEFAULT` values during the `ADD COLUMN` operation. Adding columns is a fundamental SQL skill, so master it and keep your databases evolving!
