Mysql unknown column error in delete trigger

Question

When I run:

DELETE FROM `examplecompname_empdata` WHERE `Emp_ID` = '1'

I get the following error: Unknown column 'examplecompname_empdata.Emp_ID' in 'where clause'.

I have 2 tables examplecompname_empdata and triggertable.
I've already created a delete trigger, when i delete a data in examplecompname_empdata it must delete the same id in triggertable. But after i click the delete data in my dashboard it says:

Unknown column 'examplecompname_empdata.Emp_ID' in 'where clause'
DELETE FROM `examplecompname_empdata` WHERE `Emp_ID` = '1'

I create the trigger on examplecompname_empdata with this code:

BEGIN
DELETE FROM triggertable

WHERE triggertable.id = examplecompname_empdata.Emp_ID;

END

Why am I getting this error?

It's been a while since I've last used SQL, but table.Emp_ID is a column in the table. Are you sure you have this column? PHPMyAdmin seems to be telling you that you don't have it, maybe there's a typo — flen
– flen, Commented Jan 16, 2018 at 4:40
Where is the id you want to delete in the second delete statement? Provide a complete code example. — Jeroen Heier
– Jeroen Heier, Commented Jan 16, 2018 at 4:49
sorry. my table examplecompname_empdata id is "Emp_ID" and triggertable id is "id" link i used that link for basis — chan
– chan, Commented Jan 16, 2018 at 5:30

Riad · Accepted Answer · 2018-01-16 05:48:06Z

0

I think you the AFTER DELETE statement in trigger definition.

// begining codes.....FOR EACH ROW
BEGIN
   DELETE FROM triggertable

   WHERE triggertable.id = OLD.Emp_ID; // not the table.id 

END

See MYSQL DELETE TRIGGER

answered Jan 16, 2018 at 5:48

Riad

3,8585 gold badges30 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

Mysql unknown column error in delete 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