Fetching data from another table not working mysql trigger

Question

I have a trigger like this

 CREATE
 TRIGGER `hrm_to_odm_user` AFTER INSERT
 ON `ohrm_user`
 FOR EACH ROW BEGIN
  DECLARE _dep_id INTEGER;
        SELECT eeo_cat_code INTO _dep_id FROM hs_hr_employee WHERE emp_number = NEW.id;
  INSERT INTO zodm_user (id, username, password, department) VALUES (NEW.id, NEW.user_name, NEW.user_password, _dep_id);
    END

After inserting data to ohrm_user i fire the trigger to insert values to zodm_user

It works fine for everything else other than this field _dep_id which i select from another table named hs_hr_employee

I have gone thru this post

MySQL Trigger Update with select from another table

but it is not working for me

Thanks

Nipun Ambastha · Accepted Answer · 2012-11-06 08:58:51Z

0

Try something like this

_dep_id = ID hs_hr_employee WHERE emp_number = NEW.id;

Also use profiler to see what query its firing up

answered Nov 6, 2012 at 8:58

Nipun Ambastha

2,5931 gold badge17 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Fetching data from another table not working mysql trigger

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related