MySQL Forums
Forum List  »  Triggers

Re: issues with triggers
Posted by: Juanito Juanito
Date: May 26, 2014 11:16AM

Please note that the sentence
UPDATE `parque_novo_indice`.`area` SET `area_pai`='1' WHERE `area_id`='1';

should and inser sucha as

INSERT INTO `parque_novo_indice`.`area` (`area_id`, `area_pai`, `nome`) VALUES ('15', '1', '233');


mysql Ver 14.14 Distrib 5.6.17, for Win32 (x86)

Options: ReplyQuote


Subject
Views
Written By
Posted
2755
May 26, 2014 11:09AM
Re: issues with triggers
1141
May 26, 2014 11:16AM
1134
May 28, 2014 10:27AM
1221
May 27, 2014 03:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.