|
From: Gerd W. <ger...@t-...> - 2017-04-29 10:59:27
|
Sorry my last redundant answer that John had already given. Am 25.04.2017 um 21:34 schrieb KARR, DAVID: > 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. This should be due to our MYSQL Plugin (MariaDB is based on MYSQL). See menu File -> Global preferences -> Tab MySQL -> The procedure separator is by default set to '|'. Change it for example to ';' and the problem should be gone. |
