Re: LAST_INSERT_ID and CRC32

[Thomas Pundt]

Johnny Withers schrieb:
> Well, I think an update after insert is the only way. Other than
> perpopulating another table with possibe crc values then usinga join:
> 
> Select id from testtable
> Inner join crctable on testtable.id=crctable.id
> Where crctable.crcval='xxxxxxx'
> 
> Just be sure to index the crcval column.

 From my understanding, a TRIGGER might do exactly what Thunder needs.

http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html

Ciao,
Thomas Pundt