mysql show命令大全

1. SHOW DATABASES;
2. SHOW TABLES;
3. SHOW COLUMNS FROM table_name;
4. SHOW INDEX FROM table_name;
5. SHOW CREATE DATABASE database_name;
6. SHOW CREATE TABLE table_name;
7. SHOW GRANTS FOR user_name;
8. SHOW STATUS;
9. SHOW VARIABLES;
10. SHOW PROCESSLIST;
11. SHOW ERRORS;
12. SHOW WARNINGS;
13. SHOW CHARACTER SET;
14. SHOW COLLATION;
15. SHOW ENGINES;
16. SHOW FUNCTION STATUS;
17. SHOW TRIGGER STATUS;
18. SHOW PROCEDURE STATUS;
19. SHOW PLUGINS;
20. SHOW EVENTS;
21. SHOW FULL PROCESSLIST;
22. SHOW MASTER STATUS;
23. SHOW SLAVE STATUS;
24. SHOW BINLOG EVENTS;
25. SHOW PRIVILEGES;
26. SHOW PROFILE;
27. SHOW PROFILES;
28. SHOW TABLE STATUS;
29. SHOW VARIABLES LIKE '%pattern%';
30. SHOW TABLES FROM database_name LIKE '%pattern%';
31. SHOW TRIGGERS;
32. SHOW CHARACTER SET LIKE '%pattern%';
33. SHOW COLLATION LIKE '%pattern%';
34. SHOW FULL COLUMNS FROM table_name;
35. SHOW FULL INDEX FROM table_name;
36. SHOW ENGINE INNODB STATUS.