Re: mySQL TRIGGER problem

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 363,474 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,528 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser:

mySQL TRIGGER problem

•

Join Date: Apr 2008

Posts: 248

Reputation: tesuji is an unknown quantity at this point

Rep Power: 1

Solved Threads: 29

tesuji

Offline

Posting Whiz in Training

Re: mySQL TRIGGER problem

May 9th, 2008

hi,
what is the error message?

Your trigger will be fired AFTER update, and, obviously, it were to catch update errors IF the record to be updated does not exist in your table. Well, if that record does not exist, update would not be execute, therefore (i believe so

) AFTER-update trigger will never be fired.

If you want to prevent failure, if a record to be inserted already exists (that would lead into duplicate primary key), you might use

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
INSERT INTO TABLE (...) VALUES (...) ON DUPLICATE KEY UPDATE ....
INSERT INTO table (...) VALUES (...) ON DUPLICATE KEY UPDATE ....

krs,
tesu

Forum Highlights

Related Features

DANIWEB FEATURE INDEX

Statistics

Members: 363,474

Users Online Now: 3,528

Active IRC Users: 32

Forum Threads: 120,657

Forum Posts: 627,625

Code Snippets: 838

Blogs: 139

Blog Entries: 1,893

Directory Links: 538

DaniWeb Home > Forums > Web Development > Databases > MySQL > mySQL TRIGGER problem

Re: mySQL TRIGGER problem

mySQL TRIGGER problem

Re: mySQL TRIGGER problem