mysql命令行查看存储过程表等常用命令,
查看table
mysql> show tables;
+--------------------+
select name from mysql.proc where db='your_db' and type='PROCEDURE';
mysql> select name from mysql.proc where db='XX' and type='PROCEDURE'; +-------------------+ | name | +-------------------+
查mysql数据库中的表,显示所有的存储过程,查看存储过程源码mysql> SHOW CREATE PROCEDURE proc_word;
+-----------+---------------------------
强大的show命令,查看表函数,存储过程,触发器的源码,可以同通过一下命令
SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [like_or_where]
SHOW CREATE DATABASE db_name
SHOW CREATE EVENT event_name
SHOW CREATE FUNCTION func_name
SHOW CREATE PROCEDURE proc_name
SHOW CREATE TABLE tbl_name
SHOW CREATE TRIGGER trigger_name
SHOW CREATE VIEW view_name
SHOW DATABASES [like_or_where]