jeudi 18 décembre 2014

DBEAVER: SQL error or missing database (near ",": syntax error)


I'm using DBeaver (because Base only works on OS X) to work with an SQLite database. When I attempt to execute the following query, I get the error message 'SQL error or missing database (near ",": syntax error)', even though I've specified the database and table:



INSERT INTO `contacts`.`contacts` (`fname`, `sname`, `dob`) VALUES ('MTN', 'Account', NULL), ('A', 'Person', -20456000), ('Local', 'Police', NULL), ...;


contacts is the database, containing a table named contacts with the following structure:



CREATE TABLE `contacts` (
`cid` INTEGER NOT NULL AUTO_INCREMENT,
`fname` TEXT NULL,
`sname` TEXT NOT NULL,
`dob` INTEGER NULL
);


I can use the + button to insert rows, but I'd prefer to perform bulk inserts.


I've already looked at the SQLite INSERT documentation and it looks exactly the same as MySQL's, so I don't see why it's having a hissy fit.





Aucun commentaire:

Enregistrer un commentaire