摘要: SET GLOBAL log_bin_trust_function_creators = 1; DELIMITER $$ CREATE FUNCTION pro_salary_grade( salary INT) RETURNS CHAR BEGIN DECLARE grade CHAR DEFAU 阅读全文
posted @ 2020-04-06 13:59 Draymond 阅读(13172) 评论(0) 推荐(0) 编辑
摘要: DELIMITER $$ CREATE PROCEDURE pro_insert(IN maxNum INT) BEGIN DECLARE i INT DEFAULT(1); while i<=maxNum DO INSERT INTO employees (first_name ,last_nam 阅读全文
posted @ 2020-04-06 13:06 Draymond 阅读(3252) 评论(0) 推荐(0) 编辑
摘要: # 无参存储过程 DELIMITER $$ CREATE PROCEDURE pro_insert_employees() BEGIN insert into employees (first_name,last_name) VALUES("1","1"),("2","2"),("3","3"); 阅读全文
posted @ 2020-04-06 12:18 Draymond 阅读(186) 评论(0) 推荐(0) 编辑