.ben,
Monday, May 20, 2002, 3:15:11 PM, you wrote:
b> hi. i'm new to the list and have only been playing with mySQL for a few
b> weeks now, i have a question regrading the syntax of an UPDATE statement - i
b> hope nobody minds me asking.
b> i want to uopdate a table with the data from another,
cheers for the responses. i'll have to find another way, but thanks.
.b
> -Original Message-
> From: Nick Stuart [mailto:[EMAIL PROTECTED]]
> Sent: 20 May 2002 13:46
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: UPDATE question, SQL syntax, etc.
>
There is no from clause in the update syntax. However, I'm not sure how
you would update a tablethe way you are trying to. I'm sure it can be done, and your
SQL looks
correct besides the fromclause. Just take that out and see if what it says.
-Nick
> hi. i'm new to the list and
have only been
[snip]
update trackinfo SET trackinfo.postcode = newtrackinfo.postcode FROM
trackinfo, newtrackinfo WHERE trackinfo.telephone = newtrackinfo.telephone;
[/snip]
http://www.mysql.com/doc/U/P/UPDATE.html
MySQL does not support sub-queries, such as the one you are attempting here.
(the "FROM" on..) Y
hi. i'm new to the list and have only been playing with mySQL for a few
weeks now, i have a question regrading the syntax of an UPDATE statement - i
hope nobody minds me asking.
i want to uopdate a table with the data from another, i've written the
following:
update trackinfo SET trackinfo.post
