存储过程和函数:创建示例代码:DELIMITER $$CREATE PROCEDURE proc(IN c_id INT, IN c_name VARCHAR(20), OUT count INT)READS SQL DATABEGIN SELECT * FROM cours ...
存储过程和函数:
创建示例代码:
DELIMITER $$CREATE PROCEDURE proc(IN c_id INT, IN c_name VARCHAR(20), OUT count INT)READS SQL DATABEGIN SELECT * FROM course WHERE cou_no = c_id OR cou_name = c_name; SELECT FOUND_ROWS() INTO count;END $$DELIMITER
原标题:MySQL存储过程和函数
关键词:MYSQL
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。