insert statement
hi, i am trying to change the value of password in a table called Author. I am referenceing a value called Auth_ID and setting a new value to the password.
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?
Subject
Written By
Posted
insert statement
April 21, 2005 01:49PM
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.