|
From: John H. <jh...@im...> - 2017-04-25 21:57:14
|
On Tue, 25 Apr 2017, KARR, DAVID wrote: > 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. Take a look at Session -> Session Properties -> SQL tab -> Statement Separator, is that perhaps set to vertical bar? It doesn't make any sense for that to be the case, but that is one thing that can cause Squirrel to break the parsing of SQL midway through. -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- We should endeavour to teach our children to be gun-proof rather than trying to design our guns to be child-proof ----------------------------------------------------------------------- 26 days since the first commercial re-flight of an orbital booster (SpaceX) |
