Need to create a little complex trigger for MySQL DB ...and test it
There will be 3 tables (T1, T2, T3)
Once a record inserted in T1 a trigger will fire
The trigger should do this
Capture the record columns
One column consists of two words separated by space.
Capture the words separately
Compare the words , with rows in T3 .
If they match get the text from T3, column3.
Insert T1 & processed T3 values in T2 details
Inside the trigger you may need to use cursor etc...
Oe important thing is the trigger should be quick enough to process the each T1 inserted row.
In T1 lot of rows will be inserted per second.
Will provide you with table details
8 freelanceria on tarjonnut keskimäärin 203 $/tunti tähän työhön
Please look my profile and last works. I have already developed multiple complex triggers and SP as part of different projects and all are working fine. I will provide best solution in short duration.