MySQL Forums
Forum List  »  Newbie

Re: insert statement
Posted by: Felix Geerinckx
Date: April 21, 2005 02:28PM

Chris Miros wrote:

> The insert statement i have for this goes:
>
> Insert into Author (password) values ("fred")
> where Auth_ID =1
>
> and i keep getting error no 1064. I am using
> Mysql 4.1.11-nt
>
> is there anything wring with this statement?

You cannot invent your own syntax and expect it to work. Try

UPDATE Author SET password = 'fred' WHERE Auth_ID = 1;

--
felix

Options: ReplyQuote


Subject
Written By
Posted
April 21, 2005 01:49PM
April 21, 2005 02:07PM
April 21, 2005 02:19PM
April 21, 2005 02:41PM
Re: insert statement
April 21, 2005 02:28PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.