mysql实用技巧...

显示可用数据库 show databases;
显示表索引 show keys from TABLE_NAME;
显示表信息 show table status like 'TABLE_NAME';
授权 grant all priviledges on DB_NAME.* to 'USER_NAME'@'%' identified by 'PASSWORD' with grant option.
创建数据库 create database DB_NAME charact set utf8
创建表 carate table (...) type=INNODB
查看当前连接数 show processlist
查看服务器状态 show status