Re: [Squirrel-sql-users] Semicolon problem

[Robert M. <rob...@gm...>]

I wasn't able to reproduce it with this script (';' near the end of
the url - a;2 ) :

create table testurl (myid integer, myurl varchar(255))

INSERT INTO testurl (MYID,MYURL) VALUES
(0,'http://foo.com:8080/bug.cgi?key=1&val=a;2');
INSERT INTO testurl (MYID,MYURL) VALUES
(1,'http://foo.com:8080/bug.cgi?key=1&val=a;2');
INSERT INTO testurl (MYID,MYURL) VALUES
(2,'http://foo.com:8080/bug.cgi?key=1&val=a;2');
INSERT INTO testurl (MYID,MYURL) VALUES
(3,'http://foo.com:8080/bug.cgi?key=1&val=a;2');

What am I doing wrong?

Rob

On Sat, Apr 4, 2009 at 10:47 AM, Teijo Aulin <tab...@gm...> wrote:
> Hi
>
> I'm importing a dump from my old mysql db and I've ran into some problems
> with semicolon and Squirrel. The problem is that in the dump (which is just
> a bunch of insert statements) I have a column that has urls. Some urls have
> semicolons in them. Each insert statement ends with a semicolon as well.
>
> When I execute the statements one by one, I have no errors. When I select
> all of the lines and run, it fails on the first line that has an url with a
> semicolon in it (and yes, I can execute that line by itself without
> problems).
>
> Helb ? Thanks.
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>