Problem with Trigger Query........

[man12_patil3]

 

 

CREATE TRIGGER ins_trig AFTER INSERT ON test

FOR EACH ROW

BEGIN

INSERT INTO test2 (id,  Name,  address,  ph ) (SELECT * FROM `test` ORDER BY id desc LIMIT 0 , 1);

END;

 

this is my query  when i try it show the following error-

"#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near "

on MySQL client version: 5.0.45

 

 

Plz help me

 

Thx in Advance.....

 

 

[Mchl]

DELIMITER $$
CREATE TRIGGER ins_trig AFTER INSERT ON test
FOR EACH ROW
BEGIN
INSERT INTO test2 (id,  Name,  address,  ph ) (SELECT * FROM `test` ORDER BY id desc LIMIT 0 , 1);
END$$

DELIMITER ;

 

BTW: why not

INSERT INTO test2 (id,  Name,  address,  ph ) VALUES (NEW.id, NEW.Name, NEW.address, NEW.ph);