AJDIN BRANDIC writes:
> I am running MySQL 3.22.30 and UPDATE IGNORE is failing. Was this > function introduced in some later version? Probably. You really should consider upgrading. 3.23 has been out for ages now. > What is a work around? I fail to see a situation where you would actually want to do what UPDATE IGNORE allows you to do, but since you need it, I guess my imagination is at fault. The solution I can think of would be to lock the table, select all rows that you want to update, and then update them one at a time. This assumes that there is some unique index, which there of course is (or you wouldn't be needing UPDATE IGNORE). I know this isn't a good solution, but it's the best I can think of. I'd rather just upgrade to 3.23 though. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php