Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
Date: Thu, 14 Feb 2008 13:25:06 +0100
From: "Bernt M. Johnsen" <Bernt.Johnsen@Sun.COM>
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: sql format in *.sql files
Message-ID: <20080214122506.GB29038@khepri35.norway.sun.com>
References: <15479296.post@talk.nabble.com>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="+pHx0qQiF2pBVqBT"
Content-Disposition: inline
In-Reply-To: <15479296.post@talk.nabble.com>
Organization: Sun Microsystems
User-Agent: Mutt/1.5.7i


--+pHx0qQiF2pBVqBT
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

>>>>>>>>>>>> dexter195 wrote (2008-02-14 04:20:13):
>=20
> Hi
>=20
> I have a load of sql files that i need to be able to import into derby.=
=20
>=20
> What delimiter do i need at the end of the statements in order for derby =
to
> see it as a seperate query. i presumed that this would be ; but this does=
nt
> work. I've tried all variants i can think of but none of them work.
>=20
> insert into MeasurementColumn values
> ("test","test",1,"test",2,3,4,5,"test","test","test","test",6);
> insert into MeasurementColumn values
> ("test1","test1",1,"test1",2,3,4,5,"test1","test1","test1","test1",6);
>=20
> ERROR 42X01: Syntax error: Encountered ";" at line 2, column 129.

The statement is syntactically incorrect. You should use ' not " to
delimit strings in SQL, like this:

insert into MeasurementColumn values
('test','test',1,'test',2,3,4,5,'test','test','test','test',6);
insert into MeasurementColumn values
('test1','test1',1,'test1',2,3,4,5,'test1','test1','test1','test1',6);


--=20
Bernt Marius Johnsen, Database Technology Group,=20
Staff Engineer, Derby/Java DB
Sun Microsystems, Trondheim, Norway

--+pHx0qQiF2pBVqBT
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (SunOS)

iD8DBQFHtDMhlFBD9TXBAPARAtY/AJ4oMcLKqGRhEf1e/NIDNZ9E2s2F+wCglxWd
U6Ir5CN2bi8JghEvjrEv2gI=
=AGVV
-----END PGP SIGNATURE-----

--+pHx0qQiF2pBVqBT--