显示警告: show warnings
查看当前选定的数据库: select database();
创建数据库: create{database | schema} [if not exists] db_name [default] character set [=] charset_name
查看当前服务器下的数据库列表: show {databases | schemas} [like 'pattern' | where expr]
修改数据库: alter {database | schema} [db_name] [dafault] character set [=] charset_name;
删除数据库: drop{database | schema} [if exists] db_name
创建数据表:create table [if not exists] table_name(cloumn_name data_type,)
查看数据表: show tables [from db_name] [like 'pattern' | where expr]
查看数据表结构:show columns from db_name
使用数据库:use db_name
插入记录:insert [into] tbl_name [(col_name)...] values(val,...)
查找记录:select expr,.. from tbl_name