Re: LAST_INSERT_ID and CRC32

Yes, Triggers... I so rarely use them I forget they exist.
On Tue, May 5, 2009 at 10:22 AM, Thomas Pundt wrote:
> 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
>
--
-----------------------------
Johnny Withers
601.209.4985
johnny@pixelated.net