Käynnissä

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:

liuxinran

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 / hour
(15 arvostelua)
4.1

8 freelancers are bidding on average $203/hour for this job

eperfections

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

$25 USD / hour
(63 arvostelua)
6.1
tejas34

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 / hour
(10 arvostelua)
5.1
WSolutionsinc

Hi i can start right now. many thanks

$25 USD / hour
(6 arvostelua)
3.6
droidco

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

$15 USD / hour
(0 arvostelua)
0.0
anthakkar08

hello sir would like to help you with this project

$15 USD / hour
(0 arvostelua)
0.0
friman78

MySQL expert. Ready to start.

$15 USD / hour
(1 arvostelu)
0.0
Tn08UP6mX

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

$1500 USD / hour
(0 arvostelua)
0.0