- 数据库创建 ``` create database name; ``` - 选择数据库 ``` use databasename ``` - 删除数据库 ``` drop database name ``` - 展示表列表 ``` show tables; ``` - 查询表的详情 ``` describe tablename; ``` - 展示表的版本号 ``` select version(); ``` - 增加新用户 ``` GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY ’something’ WITH GRANT OPTION; ``` - 重新命名表 ``` alter table t1 rename t2; ``` - 备份数据库 ``` mysqldump -h host -u root -p dbname >dbname_bak.sql ```