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;