MySQL Forums
Forum List  »  Triggers

After Insert - update just one row
Posted by: Bill Donnelly
Date: January 18, 2014 01:56PM

Hello,

I am trying to emulate a function that calculates a field value when a row is inserted. It simply concatenates the record_id (which is an autoincrement field) with a string to make a unique identifier for the record.

The MySql trigger wants to update every row after insert. As we get over 1M records, I really don't want to take this performance hit.

Any ideas?

Thanks,
Bill

Options: ReplyQuote


Subject
Views
Written By
Posted
After Insert - update just one row
2405
January 18, 2014 01:56PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.