Timeline for find and insert row to another table using mysql trigger
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 9, 2013 at 5:45 | comment | added | Gord Thompson |
@dinesh.mic The current trigger fires AFTER INSERT ON employee. You'll need to create a second trigger that fires AFTER UPDATE ON employee. For more details, look here.
|
|
| Apr 9, 2013 at 3:09 | comment | added | dinesh.mic | how to write a trigger like this for fire when update on employee.division | |
| Apr 8, 2013 at 11:31 | comment | added | Gord Thompson |
@dinesh.mic Yes, that would be possible, but it would violate the principle of Normalization. If you store tools.Tool_No in employee_tools then you shouldn't also store tools.Tool_Name in employee_tools because you already have that information available from the tools table.
|
|
| Apr 8, 2013 at 11:11 | vote | accept | dinesh.mic | ||
| Apr 8, 2013 at 10:54 | comment | added | dinesh.mic | is it possible to insert into employee_tools (Id,Tool) values ('new.id', 'Tools.Tool_No & Tools.Tool_Name') ? | |
| Apr 8, 2013 at 10:27 | history | answered | Gord Thompson | CC BY-SA 3.0 |