Re: WHERE doesn't work - Barry - com.mysql.lists.mysql

27 messages in com.mysql.lists.mysqlRe: WHERE doesn't work

From	Sent On	Attachments
Tom Lobato	20 Apr 2006 10:32
Jay Blanchard	20 Apr 2006 10:35
Tom Lobato	20 Apr 2006 10:54
George Law	20 Apr 2006 11:08
Barry	21 Apr 2006 00:09
Tom Lobato	21 Apr 2006 09:49
Tom Lobato	21 Apr 2006 09:49
Tom Lobato	21 Apr 2006 10:04
Tom Lobato	21 Apr 2006 10:06
Jay Blanchard	21 Apr 2006 10:15
Tom Lobato	21 Apr 2006 10:43
Nicolas Verhaeghe	21 Apr 2006 11:49
Nicolas Verhaeghe	21 Apr 2006 12:05
Tom Lobato	21 Apr 2006 12:11
Nicolas Verhaeghe	21 Apr 2006 13:14
Nicolas Verhaeghe	21 Apr 2006 13:14
Tom Lobato	21 Apr 2006 14:31
Nicolas Verhaeghe	21 Apr 2006 14:49
Tom Lobato	21 Apr 2006 17:15
Michael Stassen	21 Apr 2006 19:12
Tom Lobato	22 Apr 2006 00:22
Tom Lobato	22 Apr 2006 00:54
Peter Brawley	22 Apr 2006 21:03
Tom Lobato	22 Apr 2006 21:35
Tom Lobato	23 Apr 2006 02:49
Peter Brawley	23 Apr 2006 09:44
Tom Lobato	23 Apr 2006 16:38

Subject:	Re: WHERE doesn't work
From:	Barry (Bar...@flyerheaven.de)
Date:	04/21/2006 12:09:03 AM
List:	com.mysql.lists.mysql

Tom Lobato wrote:

Hi!

UPDATE command is not working for only the record that I want, but for all in the table. I sees WHERE is not interpretated by Mysql server. At least the result is identic to it. For example, If my php execute

UPDATE clientes SET tipo='r', nome_fantasia='cc', estado='24' WHERE id = '5'

on the server, I have all records in the table clientes updated for these values. But, if I copy exactily this command from php output and execute in the Mysql server directly, via some mysql client, it updates only record whose id = '5'. PHP Version: 4.4.2, Mysql client API version: 3.23.49. For windows servers or Linux. Some Hint?

Thank you Tom

Tried: WHERE id = 5 ?