book表和book_update表都建立了,并且字段没有问题
CREATE
TRIGGER `dlht`.`update_book_insert_book_update` AFTER UPDATE
ON `dlht`.`book`
FOR EACH ROW
BEGIN
IF NEW.book_name<>OLD.book_name THEN
insert into book_update values(1,OLD.book_id,OLD.book_name,NEW.book_name,now());
END IF;
IF NEW.book_author<>OLD.book_author THEN
insert into book_update values(2,OLD.book_id,OLD.book_author,NEW.author,now());
END IF;
END;
CREATE
TRIGGER `dlht`.`update_book_insert_book_update` AFTER UPDATE
ON `dlht`.`book`
FOR EACH ROW
BEGIN
IF NEW.book_name<>OLD.book_name THEN
insert into book_update values(1,OLD.book_id,OLD.book_name,NEW.book_name,now());
END IF;
IF NEW.book_author<>OLD.book_author THEN
insert into book_update values(2,OLD.book_id,OLD.book_author,NEW.author,now());
END IF;
END;
具体有什么问题
insert into book_update values(1,OLD' at line 5
/*[DEFINER = { user | CURRENT_USER }]*/
TRIGGER `test`.`dd` AFTER UPDATE
ON `test`.`ttg`
FOR EACH ROW BEGIN
iF NEW.book_name <>OLD.book_name THEN
insert into book_update values(1,OLD.book_id,OLD.book_name,NEW.book_name,now());
END IF;
IF NEW.book_author <>OLD.book_author THEN
insert into book_update values(2,OLD.book_id,OLD.book_author,NEW.author,now());
END IF;
END$$DELIMITER ;
在MYSQL5.1。17+SQLYOG下没有问题