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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to