mysql 常用命令

DBM

修改密码

set password for user=PASSWORD('?????');

DML:

RENAME TABLE tbl_name TO new_tbl_name;

alter table tbl_xx add column    `ID_number` VARCHAR(32) NULL;

alter table tbl_xx drop column qau_owner;

drop table tbl_xx;