>>>>>>>>>>>> dexter195 wrote (2008-02-14 04:20:13): > > Hi > > I have a load of sql files that i need to be able to import into derby. > > 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 doesnt > work. I've tried all variants i can think of but none of them work. > > 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); > > 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); -- Bernt Marius Johnsen, Database Technology Group, Staff Engineer, Derby/Java DB Sun Microsystems, Trondheim, Norway
pgpNoi5AYUnD0.pgp
Description: PGP signature