Mysql beginners must learn the statement Arrangement

MySQL adds, modifies, and deletes columns. alter table: adds, modifies, and deletes TABLE columns, constraints, and other TABLE definitions.

View column: desc table name;
Alter table old _ name rename to new_name;
Add column: alter table name add column name varchar (100 );
Delete column: alter table Name drop column name;
Alter column name: alter table name change old_name new_name character type;
Modify column attributes: alter table name modify column name varchar (10 );

This article is from the "java technology community" blog