MySQL建立觸發器時報錯Error Code: 1064

原來

CREATE TRIGGER user_insert
AFTER INSERT 
    on users
    FOR EACH ROW
    BEGIN
    INSERT INTO num(  ) VALUES 
                                        (new.id );

修改後

delimiter //

CREATE TRIGGER user_insert
AFTER INSERT 
    on users
    FOR EACH ROW
    BEGIN
    INSERT INTO num(  ) VALUES 
                                        (new.id );
    END//

本作品採用《CC 協議》，轉載必須註明作者和本文連結