After Insert - update just one row

[Bill Donnelly]

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