MySQL Forums
Forum List  »  Newbie

Error 1064
Posted by: Phil Kenport
Date: November 10, 2017 04:46AM

- Getting the 1064 error when trying to UPDATE DEFINER:

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

The following error msg appears:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''name_db.routinename' SET definer='username@%' WHERE definer=' at line 1

Options: ReplyQuote

Written By
Error 1064
November 10, 2017 04:46AM
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.