Now that I've turned off variable interpolation in my big sql import script, when I run it, it gets an odd error on a particular insert line. It looks somewhat like this (mostly elided, except for the start of the values list):
insert into blah (colname1,colname2,colname3,...) values (371,null,'433449 | 274027 - ...
In the error message, it says the syntax error is near "433449", and when it shows the entire query, the end of the line is the "9" at the end of that number. It seems like that vertical bar character is doing something.
I don't know whether this is a mysql/mariadb issue, or SQuirreL.
|