MySQL Forums
Forum List  »  MySQL Workbench

substitution variable prompt on "&" - connecting from sql developer
Posted by: Deepak Tiwari
Date: October 31, 2020 12:09AM

I am connecting to remote MYSQL 8 from oracle sql developer. When running sql script to insert data it takes "&" as identifier for substitution variable instead of data. while set define off does not work in mysql, is there a standard way to disable substitution variable prompting on every occurrance of "&" ??

Options: ReplyQuote


Subject
Views
Written By
Posted
substitution variable prompt on "&" - connecting from sql developer
66
October 31, 2020 12:09AM


Sorry, only registered users may post in this forum.

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.