trigger question

[asucrews]

I am trying get triggers to work, but i not sure were my sytex error is. any ideas

test_1
id text

test_2
id text date_added

CREATE TRIGGER test_audit BEFORE INSERT ON test_1
FOR EACH ROW
BEGIN  

    INSERT INTO test_2 (`id`, `text`, `date_added`)
    VALUES (test_1.id,test_1.text, UNIX_TIMESTAMP() )
END

[bradgrafelman]

If you just want to execute a single SQL statement, there is no need for the "BEGIN .. END" syntax at all - just remove those keywords.

Otherwise, see the MySQL manual page for CREATE TRIGGER for more info/examples.

[johanafm]

Each SQL statement has to be terminated by some character. I no longer remember if the SQL standard defines this character as ; or if that is just common practice. Either way, your insert statement found in the trigger lacks a statement terminator. Also, since you can't use the same terminator as for the entire trigger, which also needs one, you have to specify some other terminator first, and within the trigger use the original one.

I.e.in all example code you will see lines like "delimiter #" before CREATE TRIGGER, and "delimiter ;" after it. Those two lines are very important.