在提问之前,我搜索了一些帖子,但没有找到类似的问题,如果我错过了某些内容,请见谅。
这是我的问题。我在SQLite Administrator中创建了一个表和它的字段,然后我编写了以下查询来填充该表:
USE Contact_Database;
INSERT into Names (Contact_ID, FirstName, LastName) VALUES
(1, 'Joana', 'Tavares'),
(2, 'Patrícia', 'Dias'),
(3, 'Paulo', 'Costa'),
(4, 'Marco', 'Almeida'),
(5, 'Bruno', 'Lindo'),
(6, 'Manuela', 'Lindo'),
(7, 'João', 'Lindo'),
(8, 'Rui', 'Trindade');
Result error: SQL Error: near "USE": syntax error
I've also tried with:
INSERT into Contact_Database.Names
Result error: SQL Error: near ",": syntax error <
What am I missing here?