摘要:
数据库循环、触发器、队列、事务、外键 一、数据库循环 循环 LOOP DECLARE x number; BEGIN x := 0; <<repeat_loop>>[跳转标志] x := x + 1; [代码块] IF x < 9 THEN[跳转限制] GOTO repeat_loop;[跳转标志] 阅读全文
摘要:
SELECT CASE 3 WHEN 1 THEN 'one' WHEN 2 THEN 'two' ELSE 'more' END; SELECT CASE WHEN 1 > 0 THEN 'true' ELSE 'false' END AS 'one', CASE WHEN 0 > 0 THEN 'true' ... 阅读全文