MySQL Forums
Forum List  »  Newbie

Re: Error #1064 SQL syntax at line 1 - strange characters
Posted by: Ryan Albert Rucas
Date: September 05, 2011 10:52AM

@Josh

sir, arent you going with this syntax

UPDATE <tablename>
SET <columnname> = 'value'
WHERE<id> = 'id';

UPDATE user
SET Password = 'PASSWORD'
where user = 'root';

Options: ReplyQuote




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.