From: Johnny Withers (johnnypixelated.net)
Date: Tue May 05 2009 - 21:54:31 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Yes, Triggers... I so rarely use them I forget they exist.

On Tue, May 5, 2009 at 10:22 AM, Thomas Pundt <mlistsrp-online.de> 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
johnnypixelated.net

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]