man12_patil3 Posted March 3, 2010 Share Posted March 3, 2010 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..... Link to comment https://forums.phpfreaks.com/topic/193985-problem-with-trigger-query/ Share on other sites More sharing options...
Mchl Posted March 3, 2010 Share Posted March 3, 2010 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); Link to comment https://forums.phpfreaks.com/topic/193985-problem-with-trigger-query/#findComment-1020852 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.