Follow this topic

Ahmed Abu Musallm

Last answered:

05 Jun 2023

Posted on:

02 Jun 2023

0

salaries table not updated

in SQL / MySQL Triggers

salaries table not updated, i don't know why, vules inserted correctly on dept_manager table but salaries not updated ..

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

05 Jun 2023

0

Hi Ahmed!
Thanks for reaching out!

Could you please use the query for the insertion outside the trigger? Thank you.

Hope this helps.
Best,

Tsvetelin

Submit an answer

related questions

3

28

Rollback not reverting DB state after using INSERT INTO

Sivarajan Sivakumar

0

18

Cannot insert 999903 into the dept_emp table?

Marcus Wern Han Leong

2

16

Why did you not do not null, primary key and auto increment for customer id in the solution?

Harsha Dharmabandu

1

14

Resolved: foreign key : able to see foreign key in the table sales DDL tab , but the Foreign Keys tab is empty

1

14

Resolved: employees.sql database not found in resources

Abdelrahman Samy

0

14

Resolved: why this code not valid

0

12

Resolved: MySQL set up a connection not working?

Mohamed AbdulHalim

0

12

Resolved: Playing the text in the video does not work, although I have cc enabled, what is the solution please