Hi everybody

I sent a couple of mail recently, asking some help for some strange
behaviour with select and updates.
I hope many of you have read it...the problem was that making a 

SELECT something FROM table WHERE 'Where_Clause'

gave some results, >0.

the query:

UPDATE table SET something WHERE 'THe_Same_Clause_As_Before'

gave:

0 matching rows, 0 rows changed.

that seemed to me strange, so that I started to investigate about my
tables and indexes.

I was using Mysql-4.0.1-alpha.

I decided to update, switching to version 4.0.11-gamma.

The problem has disappeared!

Maybe it was a bug.

I hope this can be useful for someone.

Daniele


---------------------------------------------------------------------
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

Reply via email to