Postgres Error : syntax error at or near "(" [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed 4 years ago.

Improve this question

I am getting this error

ERROR: syntax error at or near "("Position: 65```

for the following query

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))

You need to quote your string values, remove double () from values and add , after each values sequence — Justinas
– Justinas, Commented Jun 23, 2021 at 8:39

Tamim Al Manaseer · Accepted Answer · 2021-06-23 08:39:43Z

3

Probably you need commas between paranthesis for each record. And "Kenit" should be in quotes

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))

answered Jun 23, 2021 at 8:39

Tamim Al Manaseer

3,7543 gold badges27 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Kenit Over a year ago

Thanks, man, it helped I forgot commas in between two records.

user330315 Over a year ago

@KenitPatel The outer most pair of parentheses is not needed for the VALUES clause. so values (1, ...), (2, ...) is enogh

Daniel Gran · Accepted Answer · 2021-06-23 08:41:00Z

0

Try googling. Source: 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));

happy to help

also: phone numbers should be saved in strings, as well as your names. so adding quotation marks helps not only in readability of the code it gives required LOGIC:

example:

...('asdf', 123, '+8920841209')

answered Jun 23, 2021 at 8:41

Daniel Gran

11 bronze badge

Collectives™ on Stack Overflow

Postgres Error : syntax error at or near "(" [closed]

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related