mysql 存储过程

相关文档：https://blog.csdn.net/Forlogen/article/details/50618565 navicat mysql操作

1.代码

BEGIN

SELECT count(*) INTO private_img_num FROM may_private_img;

SELECT count(*) INTO private_book_num FROM may_private_book;

SELECT count(*) INTO private_audio_num FROM may_private_audio;

SELECT count(*) INTO private_art_num FROM may_private_art;

END

2.参数

OUT private_img_num INT,OUT private_book_num INT,OUT private_audio_num INT,OUT private_art_num INT

3.函数名

get_private_num

4.thinkphp5存储过程

Db::query('call get_private_num(@private_img_num,@private_book_num,@private_audio_num,@private_art_num)');
$res = Db::query('select @private_img_num,@private_book_num,@private_audio_num,@private_art_num')[0];
dump($res);

5.。。。

ok