MySQL 2 modify table

1 Modifying table names
Rename table AAA to BBB;
Or
Rename table AAA to BBB;
2 Modifying the data type of a field
ALTER TABLE person modify name varchar (20);

3 modifying field names
ALTER TABLE person change stu_name name varchar (25);
4 Adding a field without integrity constraints
ALTER TABLE person add sex Boolean;
5 adding fields to the table header
ALTER TABLE person add num int primary key first;
6 Adding a field at the specified location
ALTER TABLE person add birth date after name;
7 Delete a field
ALTER TABLE person drop sex;

MySQL 2 modify table