SELECT SUM(volume) INTO vVOL
FROM shipment
WHERE trip_num=:NEW .trip_num;
SELECT vol_capacity INTO vTRUCK_VOL
FROM trip p, truck k
WHERE p.truck_num=k.truck_num AND p.trip_num=:NEW .trip_num;
IF (vVOL+:new.volume)>vTRUCK_VOL THEN
;
END IF;
END$$
DELIMITER ;
以下报错
Query : CREATE
TRIGGER `abc`.`volumecheck` BEFORE INSERT
ON `abc`.`shipment`
FOR EACH ROW
BEGIN
DECLARE vVOL,vTRU...
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':new .trip_num;
SELECT vol_capacity into vTRUCK_VOL
FROM trip p, truck k
WHERE p' at line 12