MySQL Database trigger

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

That's all.

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

Taidot: MySQL

Näytä lisää: mysql database trigger, mysql test, rows insert, mysql inserted, insert mysql table, mysql table text insert, mysql record, mysql create table, mysql tables rows, mysql quick, use trigger mysql, mysql audit trail trigger database, create mysql database, insert mysql, create table mysql, mysql column row, mysql compare record, compare record record mysql database, mysql record compare, mysql create table text, values database, mysql database details, t1, mysql trigger database send emails, mysql database compare

Tietoa työnantajasta:
( 0 arvostelua ) Bangalore, India

Projektin tunnus: #1718016

Myönnetty käyttäjälle:


Hi, I have been a MySQL DBA for four years, I'm confident about MySQL routine coding. I can do this work for you.

$16 USD / tunti
(15 Arvostelua)

8 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön


I am experienced database programmer and its a one hour job for me. Please provide me 3 tables with sample data.

$25 USD / tunti
(63 arvostelua)

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.

$15 USD / tunti
(10 arvostelua)

Hi i can start right now. many thanks

$25 USD / tunti
(6 arvostelua)

Check [url removed, login to view] me complete detail.

$15 USD / tunti
(0 arvostelua)

hello sir would like to help you with this project

$15 USD / tunti
(0 arvostelua)

MySQL expert. Ready to start.

$15 USD / tunti
(1 arvostelu)

Custom software development - <b><i>Removed by Admin</i></b>

$1500 USD / tunti
(0 arvostelua)