Jump to content

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


man12_patil3

Recommended Posts

:shrug:

 

 

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

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);

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.