MySQL Forums
Forum List  »  Newbie

Re: Error 1064
Posted by: Phil Kenport
Date: November 07, 2017 01:43AM

Getting the 1064 error when trying to UPDATE DEFINER:

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

The following 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
September 15, 2017 01:59AM
September 15, 2017 08:34AM
Re: Error 1064
November 07, 2017 01:43AM
November 09, 2017 03:36AM

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.