My guess is that you have an SQL query that is something like:
query("select * from table where name = "John" and dept = 7")
The problem then is that the double quotation mark right before John is
actually *ending* the double quote that started your query string. What you
want is to escape the quotation mark around John, (or better yet, just use
a single quote), so something like:
query("select * from table where name = 'John' and dept = 7")
or
query("select * from table where name = \"John\" and dept = 7")
should work.
-Jacob
On Tue, Jun 14, 2016 at 9:50 AM, Ingemar Skarpås <[email protected]> wrote:
>
>
> Last week I started to evaluate Julia to see if it fits my purposes (I
> made some test a year and half ago also) , so I have tested a few things
> written some tests of my own, and modified some sample code. So bare with
> me if this is an easy one...
>
> I have Julia 0.4.5, with MySQL 0.2.2+ on W7U and MariaDB 10.0.17 I have
> create a database which is set to be the default and then tries to execute
> the sample code with the MySQL.jl from that Github. I used Atom 1.8.0.
> Everything is updated!
>
> The running the sample code, the table is correctly created, but when
> executing the line with the SELECT INSERT it gives an Error on the file
> name refering to the line number after that line. In my case an empty line.
> (So, I found out that Atom's error message window can't be copied from!).
> So manually typed...
>
> LoadError:UdefVarError: @John_str not defined
> in include_string at loading.jl:282
> in include_String at C:\Users\Myname\.julia\v.04\CodeTools\src\eval.jl:32
> in anonymous at C:\Users\Myname\ .julia\v0.4\Atom\src\eval.jl:84
> in withpath at C:\Users\Myname\.julia\v0.4\Requires\src\requires.jl:37
> in withpath at C:\Users\Mname\.julia\v0.4\Atom\src\eval.jl:53
> [inlined code] from C:\Users\Myname\.julia\v0.4\Atom\src\eval.jl:83
> in anonymour at task.jl:58
> while loading C:\Julia_Code\test_Mysql_localhost.jl, in expression
> starting on line 16
>
> The odd thing - running the test suite that is located from my local MySQL
> test directory with Pkg.test("MySQL") is ok! And, that test suite (3 files
> are run) also uses SELECT INTO, but in a much more complicated way!
>
> So, what is the problem? I have been staring myself blind so far
>
