摘要:
SET GLOBAL log_bin_trust_function_creators = 1; DELIMITER $$ CREATE FUNCTION pro_salary_grade( salary INT) RETURNS CHAR BEGIN DECLARE grade CHAR DEFAU 阅读全文
摘要:
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 阅读全文
摘要:
# 无参存储过程 DELIMITER $$ CREATE PROCEDURE pro_insert_employees() BEGIN insert into employees (first_name,last_name) VALUES("1","1"),("2","2"),("3","3"); 阅读全文