Postgres 错误："("或接近 的语法错误

Question

我收到这个错误

---

错误："处或附近的语法错误；("位置：65``

---

用于以下查询

---

insert into  Employee(no,name,phone) values ((1,Kenit,999999999)(2,Kenit,999999999)(3,Kenit,999999999)(4,Kenit,999999999)(5,Kenit,999999999)(6,Kenit,999999999))

Answer 1

可能您需要在每条记录的同义词之间使用逗号。并且"；Kenit"；应在报价中

insert into  Employee(no,name,phone) values ((1,'Kenit',999999999),
(2,'Kenit',999999999),(3,'Kenit',999999999),(4,'Kenit',999999999),
(5,'Kenit',999999999),(6,'Kenit',999999999))

Answer 2

尝试谷歌搜索。来源：https://www.sqlservertutorial.net/sql-server-basics/sql-server-insert-multiple-rows/

INSERT INTO table_name (column_list)
VALUES
(value_list_1),
(value_list_2),
...
(value_list_n);

INSERT INTO Employee (no,name,phone) VALUES ((1,Kenit,999999999),(2,Kenit,999999999),(3,Kenit,999999999),(4,Kenit,999999999),(5,Kenit,999999999),(6,Kenit,999999999));

很乐意帮助

另外：电话号码和你的名字都应该用字符串保存。因此，添加引号不仅有助于代码的可读性，它还提供了所需的LOGIC:

示例：

...('asdf', 123, '[phone]')