Create Trigger Syntax MYSQL V 5.5.8

[Mark McCutcheon]

Hi,

I have a database in version 5.5.8 with 6 tables as follows:

artists
exhibitions
exhibitions_items
for_sale
items
sold

I want to create a trigger such that, after insertion of an item into the items table, it is also inserted into the for_sale table.

I have tried to write some code within phpmyadmin along the lines of

CREATE OR REPLACE FUNCTION trigger
RETURNS SETOF ITEMS AS
$$
BEGIN
INSERT INTO for_sale('ID', 'Price') Values(select max id FROM items
Return TABLE(Select * From for_sale WHERE on INSERT));
END;

I believe however this is wrong as I am getting an error message.

Could anyone assist as I need to finish this urgently.

Thanks