MySQL Forums
Forum List  »  Newbie

Re: Error 1064
Posted by: Phillip Ward
Date: November 10, 2017 08:46AM

Single quote ("'", string/date literal delimiter) <> backtick ("`", identifier delimiter)

Try something more like this:

UPDATE `name_db`.`routinename` 
SET    definer = 'username@%' 
WHERE  definer = 'username@'

Or, better still, dispense with the backticks altogether - you should never actually need them, assuming you choose your table and column names wisely.

Regards, Phill W.

Options: ReplyQuote

Written By
November 10, 2017 04:46AM
Re: Error 1064
November 10, 2017 08:46AM
November 12, 2017 02:52PM
November 12, 2017 06:45PM
November 12, 2017 11:40PM
November 13, 2017 09:00AM
November 13, 2017 01:47PM
November 13, 2017 11:59AM
November 13, 2017 08:58AM
November 13, 2017 02:26AM

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.