Mysql beginners must learn how to sort the statements _ MySQL

Mysql beginners must learn the statement to sort out the definitions of adding columns to bitsCN.com MySQL, modifying columns, and deleting alter table columns: adding, modifying, and deleting TABLE columns and constraints.
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 );
BitsCN.com