? ? ? ? ? ? ? 什么是存儲(chǔ)過程，簡(jiǎn)單來(lái)說存儲(chǔ)過程是一組為了完成特定功能的的SQL語(yǔ)句集。先看腳本：

#! /bin/bashhost="xxx" port="xxx" userName="xxx" password="xxx" dbname="xxx" 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 procedure ac() begin declare i int; set i=1; while i<10000 do insert into mapan values(i); set i=i+1; end while ; end $ call ac()$

create procedure是創(chuàng)建一個(gè)存儲(chǔ)過程，ac是存儲(chǔ)過程的名字。

執(zhí)行腳本文件：

| 9987 | | 9988 | | 9989 | | 9990 | | 9991 | | 9992 | | 9993 | | 9994 | | 9995 | | 9996 | | 9997 | | 9998 | | 9999 | +------+ 9999 rows in set (0.00 sec)mysql> show procedure status; +------+------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +------+------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | test | ac | PROCEDURE | root@localhost | 2018-03-08 09:06:31 | 2018-03-08 09:06:31 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | +------+------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 1 row in set (0.00 sec)mysql>

查詢表可以看到插入了9999行數(shù)據(jù)，還可以看到我們創(chuàng)建的存儲(chǔ)過程。

總結(jié)

以上是生活随笔為你收集整理的创建存储过程批量插入数据的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。