SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

set define off on MySQL

dhalekJul 6 2015 — edited Jul 8 2015

Hello out there,

I have tried to insert a row containing an ampersand into a MySQL table but SQL Developer 4.1.1 is asking for a substitution variable. When connected to an Oracle database, I can "set define off" but that does not work on MySQL. I get an error "Unknown system variable 'define'".

So how do I insert an ampersand into MySQL?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 5 2015

Added on Jul 6 2015

#sql-developer

11 comments

3,767 views