? ? ? ? ?直接看代碼吧。

sql.sh：

#! /bin/bashhost="127.0.0.1" port="3306" username="root" password="123456" dbname="mapan" dbset="--default-character-set=utf8 -A"/usr/local/mysql/bin/mysql -h${host} -u${username} -p${password} ${dbname} -P${port} -e "source test.sql"

再看test.sql：

delimiter $ create function fun2_bok(func_id int) returns varchar(20) begin return(select * from tmp where id=func_id); end $select fun2_bok(1)$

查看存儲函數和查看原表：

mysql> show function status; Empty set (0.00 sec)mysql> select * from tmp; +------+ | id | +------+ | 1 | | 2 | +------+ 2 rows in set (0.00 sec)

執行sql.sh和查看存儲過程：

]# ./sql.sh mysql: [Warning] Using a password on the command line interface can be insecure. +-------------+ | fun2_bok(1) | +-------------+ | 1 | +-------------+ +-------+----------+----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +-------+----------+----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | mapan | fun2_bok | FUNCTION | root@localhost | 2018-05-22 09:41:07 | 2018-05-22 09:41:07 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | +-------+----------+----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+

刪除存儲函數：

mysql> drop function fun2_bok; Query OK, 0 rows affected (0.00 sec)mysql> show function status; Empty set (0.00 sec)mysql>

上面只是簡單的例子，供大家學習參考。

?

?

?

總結

以上是生活随笔為你收集整理的创建存储函数的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。