if (NOT EXISTS (select 1 from tm_order_goods WHERE order_sn='149507122391385'))
BEGIN
SELECT '找不到订单149507122391385'
end
ELSE
BEGIN
SELECT '订单149507122391385已经存在'
END
这个语法通不过
应该怎么改呢
...全文
844打赏收藏
mysql 怎么判断是否存在
if (NOT EXISTS (select 1 from tm_order_goods WHERE order_sn='149507122391385')) BEGIN SELECT '找不到订单149507122391385' end ELSE BEGIN SELECT '订单149507122391385已经存在' END 这个语法通不过 应该怎么改呢
MYSQL不支持匿名块
DELIMITER $$
CREATE PROCEDURE dd()
BEGIN
IF (NOT EXISTS (SELECT 1 FROM tm_order_goods WHERE order_sn='149507122391385')) THEN
SELECT '找不到订单149507122391385';
ELSE
SELECT '订单149507122391385已经存在';
END IF;
END$$
DELIMITER ;