MySQL存储过程里字符串拼接返回参数的方法
MySQL存储过程里字符串拼接返回参数的方法:
- BEGIN
- SET @strSql = CONCAT('SELECT ceil(COUNT(*)/5) INTO @rowCount FROM `chargingPole`.`tb_chargeStation`;');
- PREPARE s1 FROM @strSql;
- EXECUTE s1;
- DEALLOCATE PREPARE s1;
- SET pageCount = @rowCount
- END
设定一个输出参数pageCount integer,在非字符串拼接时使用into关键字
相关推荐
IT之家 2020-03-11
graseed 2020-10-28
zbkyumlei 2020-10-12
SXIAOYI 2020-09-16
jinhao 2020-09-07
impress 2020-08-26
liuqipao 2020-07-07
淡风wisdon大大 2020-06-06
yoohsummer 2020-06-01
chenjia00 2020-05-29
baike 2020-05-19
扭来不叫牛奶 2020-05-08
hxmilyy 2020-05-11
黎豆子 2020-05-07
xiongweiwei00 2020-04-29
Cypress 2020-04-25
冰蝶 2020-04-20