The following articles mainly describe the easy-to-use commands of MySQL 5, which we usually use in actual operations, if you forget it, it will cause a lot of inconvenience to some actual operations. The following is the detailed description of the article.
1. view all databases: show databases;
2. view all tables in the current database: show tables; or: show table status; or: select * from information_schema.tables;
3. view all the stored procedures: select * from MySQL. proc where db = 'db _ name' and type = 'Procedure '; or: show PROCEDURE status;
4. View All functions: select * from MySQL. proc where db = 'db _ name' and type = 'function'; or: show FUNCTION status;
5. view the source code of the stored procedure: show create procedure proc_name;
6. view the function source code: show create function func_name;
7. view all views: select * from information_schema.views;
8. View All triggers: show triggers [from db_name] [like 'expr']; or: select * from information_schema.triggers;
9. view the table structure: desc tbl_name;
The above content is an introduction to MySQL 5's easy-to-Forget commands. I hope you will get something.
The above content is a description of the easy-to-Forget MySQL 5 command, hoping to help you in this regard.
Original article title: MySQL 5 easy-to-Forget command
Connection: http://www.cnblogs.com/suyang/archive/2010/01/22/1654248.html