MySQL Forums
Forum List  »  Triggers

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


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?


Options: ReplyQuote

Written By
After Insert - update just one row
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.