Joseph
>update table
>set column5 = number1
>where column 1 = number2
>and column1 = number3
>but it is not working. I tried listing the conditions separated by
>commas (where column 1 = number2, column1 = number3) and also didn't
>work. What am I doing wrong?
No commas in the WHERE clause. WHE
seph "Tito" Kraer
Business Systems Analyst
Taylor, Bean & Whitaker Mortgage Corp
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 30, 2005 12:13 PM
To: Kraer, Joseph
Cc: mysql@lists.mysql.com
Subject: Re: Newbie Questio
Hi,
In your query you try to update on the condition "column 1 = number2 and
column1 = number3".
I think what you want is " column 1 = number2 or column1 = number3" .
If you use and it will try and found a record in column which has a value =
number2 and at the same time = number3.
hth,
mela
"Kraer, Joseph" <[EMAIL PROTECTED]> wrote on 11/30/2005 11:58:56 AM:
> I am trying to update a couple of rows in a table by doing the
> following:
>
> update table
> set column5 = number1
> where column 1 = number2
> and column1 = number3
>
> but it is not working. I tried listing the condition
I guess that the problem is the reserved word "table"
Try it:
Update `table`
Set column5=number1
where column 1 = number2
and column1 = number3
But the sintax is ok
Regards!
-Mensaje original-
De: Kraer, Joseph [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 30 de Noviembre de 2005 1
Kraer, Joseph wrote:
I am trying to update a couple of rows in a table by doing the
following:
update table
set column5 = number1
where column 1 = number2
and column1 = number3
This appears to be correct syntax.
but it is not working.
We can't help you if you don't tell us what you mean by
