[SOLVED] Trigger Problem

[toprashantjha]

Hi all,

 

      I am very new with MYSQL.. i was trying to create one trigger as mentioned in the code given bellow... But it is not creating trigger and if i remove BEGIN and END from the query then it is working fine (if i go for only on action).

any idea????

i am using  MYSQL GUI V6.0

 

CREATE TRIGGER TBL_TEST_TRIGGER AFTER UPDATE ON TBL_TEST_PRASHANT_EMPLOYEE3
  FOR EACH ROW 
BEGIN
      UPDATE TBL_TEST_PRASHANT_EMPLOYEE1 SET name = 'test' ;
      UPDATE TBL_TEST_PRASHANT_EMPLOYEE4 SET FLD_DEPT = 'test' ;
END;

[gnawz]

I think your= are using unstable SQL statements..

 

Try:

 

 

CREATE TRIGGER TBL_TEST_TRIGGER AFTER UPDATE ON TBL_TEST_PRASHANT_EMPLOYEE3

  FOR EACH ROW

 

      UPDATE TBL_TEST_PRASHANT_EMPLOYEE1 SET name = 'test', EMPLOYEE4 SET FLD_DEPT = 'test'; ;

 

 

[toprashantjha]

Thanks for the reply..

Above query is correct only ..got the solution... the problem was not using delimiter ....

[Mchl]

Exactly... what I was just going to post...

 

DELIMITER $$
CREATE TRIGGER TBL_TEST_TRIGGER AFTER UPDATE ON TBL_TEST_PRASHANT_EMPLOYEE3
  FOR EACH ROW
BEGIN
      UPDATE TBL_TEST_PRASHANT_EMPLOYEE1 SET name = 'test' ;
      UPDATE TBL_TEST_PRASHANT_EMPLOYEE4 SET FLD_DEPT = 'test' ;
END $$
DELIMITER ;

[fenway]

You might want to consider naming your trigger with a prefix that tell you when they are triggered (like "AU_" for after update).

[Mchl]

I do it as a suffix actually.