Topic: 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


please help me

thanks in Advance.....

[Mchl]

Code: [Select]

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

Code: [Select]

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