MySQL basic syntax

Add a column to a column name
ALTER TABLE table_name ADD column_name int after column_name;

Change Column Name
ALTER TABLE table_name change old_column_name new_column_name int;

Modify Type
ALTER TABLE table_name MODIFY COLUMN_NAME float;

Delete Column
ALTER TABLE table_name DROP COLUMN_NAME;

Modify Table Name
ALTER TABLE old_table_name rename new_table;

Deletion of table structure
DROP TABLE table_name (case of unexpected key) with CHECK option

Add primary Key
ALTER TABLE TABLE_NAME ADD PRIMARY key (COLUMN1,COLUMN2);

Delete primary key
ALTER TABLE table_name drop PRIMARY key;

Add constraint
ALTER TABLE table_name add unique (column_name);

Delete Constraint
ALTER TABLE table_name DROP INDEX column_name;

MySQL basic syntax