List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:May 6 2009 2:54am
Subject:Re: LAST_INSERT_ID and CRC32
View as plain text  
Yes, Triggers... I so rarely use them I forget they exist.

On Tue, May 5, 2009 at 10:22 AM, Thomas Pundt <mlists@stripped> 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
>> Where crctable.crcval='xxxxxxx'
>> Just be sure to index the crcval column.
> From my understanding, a TRIGGER might do exactly what Thunder needs.
> Ciao,
> Thomas Pundt

Johnny Withers

LAST_INSERT_ID and CRC32thunder@isfahan.at3 May
  • Re: LAST_INSERT_ID and CRC32Johnny Withers3 May
    • Re: LAST_INSERT_ID and CRC32thunder@isfahan.at3 May
      • Re: LAST_INSERT_ID and CRC32Johnny Withers4 May
        • Re: LAST_INSERT_ID and CRC32Thomas Pundt5 May
          • Re: LAST_INSERT_ID and CRC32Johnny Withers6 May
            • Re: LAST_INSERT_ID and CRC32thunder@isfahan.at6 May
    • Re: LAST_INSERT_ID and CRC32thunder@isfahan.at3 May