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
time = number3.
hth,
melanie
From: "Kraer, Joseph" <[EMAIL PROTECTED]>
To:
Subject: Newbie Question on Update
Date: Wed, 30 Nov 2005 11:58:56 -0500
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
"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
re de 2005 10:59 a.m.
Para: mysql@lists.mysql.com
Asunto: Newbie Question on Update
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 conditions se
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
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 conditions separated by
commas (where column 1 = number2, column1 = number3) and also didn't
work