/ Published in: MySQL
Simply uncomment the appropriate line for some common, useful Administration SQL statements for MySQL. (Uncomment and run 1 line at a time)
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
/* MYSQL Administration Tools */ /* Variables */ #SHOW GLOBAL VARIABLES; #SHOW SESSION VARIABLES; /* Database Objects */ #SHOW TABLES; #SHOW TRIGGERS #SHOW PROCEDURE STATUS; #SHOW FULL PROCESSLIST; /* Debugging */ #SHOW COUNT(*) WARNINGS; #SHOW WARNINGS; #SHOW GLOBAL STATUS; #SHOW ENGINE INNODB STATUS; #SHOW ERRORS; /* End */