I am writing a migration script where I replaced html encoded values by original values like &
will get replaced by &
. So my SQL query has &
letter but when I execute this query it give me popup for every &
to replace that character which is as shown below
After clicking on OK its giving anexpecetd result but actually this popup should not come for every &. What should have to do to avoid this popup?
Advertisement
Answer
At the top of your script, add:
set define off;