error in trigger

[scorpioy]

I have updated MySQL to version 5.0.0-alpha.

I was trying to create a trigger, but I always got some error.
Here is the MySQL code:

create trigger DetectNewItem
after insert on book
begin
insert into newItem values
(select c.id, c.courseName, c.title, c.edition, c.quality, c.price, c.otherInfo, c.time
from book c
where time >= CURRENT_DATE )
end;

And the error is:

ERROR 1064 at line 9: You have an error in your SQL syntax. Check the manual th
at corresponds to your MySQL server version for the right syntax to use near 'tr
igger DetectNewItem
after insert on book
begin
insert into newItem va' at line 1

Could someone tell me how to solve this error?

Thanks.

[dopey]

Hi,

I think triggers are only going to be implemented in mysql 5.1

See: http://dev.mysql.com/doc/mysql/en/ANSI_diff_Triggers.html

Stored procedures are implemented in 5.0

[scorpioy]

You are right. I should read documentation more carefully.

I'm wondering when would version 5.1 come out.