随笔分类 -  Sql-存储过程-条件结构

摘要：DELIMITER //CREATE PROCEDURE pCase2() BEGIN DECLARE vNum CHAR(20); SET vNum = 80; CASE WHEN vNum IS NULL THEN SELECT '没有分数';WHEN vNum>90 THEN SELECT ' 阅读全文

摘要：DELIMITER //CREATE PROCEDURE pTest() BEGIN DECLARE vHour INT; SET vHour =10; IF vHour>40 THEN SELECT '加班了'; END IF;END//DELIMITER ; DELIMITER //CREATE 阅读全文