FOREIGN KEY(id) REFERENCES book(id),
FOREIGN KEY(readerid) REFERENCES reader(readerid)
);
END //
DELIMITER ;
8--4
DROP TRIGGER IF EXISTS tg_goods_ins;
delimiter //
CREATE TRIGGER tg_goods_ins
AFTER INSERT ON item
FOR EACH ROW
BEGIN
UPDATE goods
SET amount=amount-new.quantity
WHERE id=new.goods_id;
END //
delimiter ;
7--13
set global log_bin_trust_function_creators=1;
delimiter //
CREATE FUNCTION staffer_search(sid INT)
RETURNS VARCHAR(10)
BEGIN
DECLARE sname VARCHAR(10);
SELECT staff_name INTO sname FROM staffer WHERE id=sid;
IF ISNULL(sname) THEN
RETURN '无人';