2020年4月6日
MYSQL ifelse语句
摘要： 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 阅读(13238) 评论(0) 推荐(0)
mysql while 循环
摘要： 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 阅读(3272) 评论(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 阅读(200) 评论(0) 推荐(0)