MySQL - SQL Table Basics - Altering/Adding Columns

Adding column

You can add new columns to an existing table.

ALTER TABLE phone
ADD   inactive_date DATETIME NULL  

GO

Alter column

You can add modify an existing column

ALTER TABLE person ALTER COLUMN lastname VARCHAR(35) NULL
GO

Considerations for altering a column

Alter columns - No Can Do

 Collapse All    Expand All
Custom Search

MySQL Information and Resources