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