MYSQL儲存過程管理
檢視儲存過程函式名:
儲存過程:(注意欄位name,type兩邊是ESC下面那個鍵)
select `name` from mysql.proc where db = 'your_db_name' and `type` = 'PROCEDURE'
show procedure status;
函式:
select `name` from mysql.proc where db = 'your_db_name' and `type` = 'FUNCTION'
show function status;
檢視儲存過程、函式程式碼:
show create procedure proc_name;
show create function func_name;
檢視檢視:
SELECT * from information_schema.VIEWS
檢視錶:
SELECT * from information_schema.TABLES //表
檢視觸發器:
方法一:
語法:SHOW TRIGGERS [FROM db_name] [LIKE expr]
例項:SHOW TRIGGERSG //觸發器
方法二:
對INFORMATION_SCHEMA資料庫中的TRIGGERS表查詢
mysql>SELECT * FROM triggers T WHERE trigger_name=”mytrigger” G
那麼,修改一個儲存過程或重新編譯一個儲存過程如下:
select `name` from mysql.proc;
tee c:1.txt
show create procedure procedure_name G
notee
drop procedure procedure_name;
delimiter //
create procedure 。。。
//
delimiter ;
select `name` from mysql.proc;
show create procedure procedure_name G
[@more@]mysql> help
For information about MySQL products and services, visit:
For developer information, including the MySQL Reference Manual, visit:
http://dev.mysql.com/
To buy MySQL Enterprise support, training, or other products, visit:
List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
? (?) Synonym for `help'.
clear (c) Clear the current input statement.
connect (r) Reconnect to the server. Optional arguments are db and host.
delimiter (d) Set statement delimiter.
ego (G) Send command to mysql server, display result vertically.
exit (q) Exit mysql. Same as quit.
go (g) Send command to mysql server.
help (h) Display this help.
notee (t) Don't write into outfile.
print (p) Print current command.
prompt (R) Change your mysql prompt.
quit (q) Quit mysql.
rehash (#) Rebuild completion hash.
source (.) Execute an SQL script file. Takes a file name as an argument.
status (s) Get status information from the server.
tee (T) Set outfile [to_outfile]. Append everything into given outfile.
use (u) Use another database. Takes database name as argument.
charset (C) Switch to another charset. Might be needed for processing binlog
with multi-byte charsets.
warnings (W) Show warnings after every statement.
nowarning (w) Don't show warnings after every statement.
For server side help, type 'help contents'
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24870090/viewspace-1037689/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL儲存過程詳解 mysql 儲存過程MySql儲存過程
- MySQL儲存過程詳解 mysql 儲存過程linkMySql儲存過程
- mysql 儲存過程MySql儲存過程
- 管理儲存過程儲存過程
- MySql儲存過程—2、第一個MySql儲存過程的建立MySql儲存過程
- mysql儲存過程整理MySql儲存過程
- MySQL之儲存過程MySql儲存過程
- [MYSQL -23儲存過程]MySql儲存過程
- mysql儲存過程例子MySql儲存過程
- mysql的儲存過程MySql儲存過程
- 【Mysql】Mysql儲存過程學習MySql儲存過程
- mysql如何呼叫儲存過程MySql儲存過程
- Mysql 儲存過程的使用MySql儲存過程
- mysql儲存過程案例解析MySql儲存過程
- mysql儲存過程詳解MySql儲存過程
- mysql儲存過程的修改MySql儲存過程
- MySQL儲存過程SAVEPOINT ROLLBACK toMySql儲存過程
- Mysql 的儲存過程和儲存函式MySql儲存過程儲存函式
- mysql 儲存過程和事件排程MySql儲存過程事件
- Laravel 中使用 MySQL 儲存過程LaravelMySql儲存過程
- MySQL 儲存過程和函式MySql儲存過程函式
- mysql儲存過程的引數MySql儲存過程
- MySql資料庫——儲存過程MySql資料庫儲存過程
- MySQL儲存過程 (即函式)MySql儲存過程函式
- MySQL儲存過程和函式MySql儲存過程函式
- mysql 遊標的使用(儲存過程)MySql儲存過程
- MySQL 建立儲存過程報錯MySql儲存過程
- mysql儲存過程小試牛刀MySql儲存過程
- 用PHP呼叫MySQL儲存過程PHPMySql儲存過程
- mysql儲存過程宣告順序MySql儲存過程
- c / c + + 呼叫mysql儲存過程MySql儲存過程
- mysql儲存過程一例MySql儲存過程
- mySql 儲存過程與函式MySql儲存過程函式
- mysql和orcale的儲存過程和儲存函式MySql儲存過程儲存函式
- Mysql 5.7儲存過程的學習MySql儲存過程
- MySQL--儲存過程與檢視MySql儲存過程
- MySQL儲存過程語句及呼叫MySql儲存過程
- MySQL儲存過程的建立和使用MySql儲存過程