sql - derby sql插入

我正在尝试在数据库中插入值
这是我尝试执行的语句:

insert into leverancier (id,naam,straat,nr,postcode,plaats,telefoon)
    values (1,"stef","bosstraat",88,9240,"Zele",null);

我收到以下错误:

ERROR 42X04: Column 'stef' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'stef' is not a column in the target table.

问题是什么？

最佳答案

要插入字符串，例如"stef"，请不要使用双引号而是单引号:'stef'。语句应如下所示:

INSERT INTO leverancier
  (id, naam, straat, nr, postcode, plaats, telefoon)
VALUES
  (1,'stef', 'bosstraat', 88, 9240, 'Zele', NULL);

您得到Column 'stef' is either not in any table ...的错误是因为表名和列名使用双引号引起来。因此，阅读"stef"时，解析器假定您正在引用名为stef的列。