MySQL | Create Tables and Add, Delete, or Modify Columns

Tags:

• MySQL
• Database

Create a Table

CREATE TABLE [table_name](id int, name varchar(20));

Rename a Table

RENAME TABLE [table_name] TO [new_table_name]

ALTER TABLE [table_name] RENAME [new_table_name];

Delete a Table

DROP TABLE [table_name];

Add a Column

ALTER TABLE [table_name] ADD [column_name] [type] [options]; 

ex) ALTER TABLE [table_name] ADD [column_name] varchar(100) not null default '0'; 

Delete a Column

alter TABLE [table_name] drop [column_name];

Rename a Column and Change Its Type

ALTER TABLE [table_name] change [column_name] [new_column_name] varchar(12);

Modify a Column Type

ALTER TABLE [table_name] MODIFY [column_name] varchar(14);