【Mysql】alter

The ALTER privilege enables use of ALTER TABLE to change the structure of tables. ALTER TABLE also requires the CREATE and           INSERT privileges. Renaming a table requires ALTER and DROP on the old table, ALTER, CREATE, and INSERT on the new table

create database Susake;

use Susake;

create table Qing(a int, b int);

alter table Qing;

rename table Qing to Test;

drop table Test;

drop database Susake;