mysql 最基础的平常操做

查看MySQL运行进程
mysql

mysql>show processlist;sql

查看Innodb引擎运行状况：ide

mysql>show engine innodb status\G进程

查看MySQL参数状况：ssl

mysql>show [global] variables like '%innodb%';it

查看MySQL运行状态：innodb

mysql>show [global] status like '%thread%';table

查看表、存储过程、触发器：class

mysql>show tables;thread

mysql>show procedure status;  show create procedure USP_Cursor;

mysql>show triggers; show create trigger TRI_UP_User_Delete;

查看MySQL帮助：

mysql>help;

mysql>help conntents;

mysql>help show;