Đã hoàn thành

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

Kỹ năng: MySQL

Xem thêm: 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

Về Bên Thuê:
( 0 nhận xét ) Bangalore, India

Mã Dự Án: #1718016

Đã trao cho:


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 / giờ
(15 Đánh Giá)

8 freelancer đang chào giá trung bình $203/giờ cho công việc này


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

$25 USD / giờ
(63 Đánh Giá)

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 / giờ
(10 Đánh Giá)

Hi i can start right now. many thanks

$25 USD / giờ
(6 Đánh Giá)

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

$15 USD / giờ
(0 Đánh Giá)

hello sir would like to help you with this project

$15 USD / giờ
(0 Đánh Giá)

MySQL expert. Ready to start.

$15 USD / giờ
(1 Đánh Giá)

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

$1500 USD / giờ
(0 Đánh Giá)