DELIMITER
-
mysql存储过程
一.demo DELIMITER $$CREATE PROCEDURE hello_procedure()BEGIN SELECT ‘hello_world’;END$$DELIM…
-
Sql-存储过程-条件结构-if then
DELIMITER //CREATE PROCEDURE pTest() BEGIN DECLARE vHour INT; SET vHour =10; IF vHour>4…
-
Sql-存储过程-条件结构-case when
DELIMITER //CREATE PROCEDURE pCase2() BEGIN DECLARE vNum CHAR(20); SET vNum = 80; CASE WHE…