MySQL ALTER TABLE Command - Complete Tutorial

Add and Modify Columns

Create a table named 'products' with columns 'id' (INT) and 'name' (VARCHAR). Then add a 'price' column of type DECIMAL(8,2) and modify 'name' to VARCHAR(150).

Expected output: A 'products' table with columns 'id', 'name' (VARCHAR(150)), and 'price' (DECIMAL(8,2)).

Hint: Use CREATE TABLE, ALTER TABLE ADD, and ALTER TABLE MODIFY commands.

Rename a Column

Rename the 'price' column in the 'products' table to 'product_price' with the same data type.

Expected output: The 'price' column is renamed to 'product_price'.

Hint: Use ALTER TABLE CHANGE clause specifying old and new column names.

Drop a Column

Drop the 'product_price' column from the 'products' table.

Expected output: The 'product_price' column is removed from the 'products' table.

Hint: Use ALTER TABLE DROP COLUMN command.

ALTER TABLE is used to modify the structure of an existing table, such as adding, dropping, or modifying columns, or renaming tables and columns.

You rename a column using the CHANGE clause in ALTER TABLE, specifying the old column name, new column name, and the column definition.

No, you must first remove the primary key constraint before dropping a column that is part of it.