php - INSERT INTO 返回操作数应包含 1 列

Question

我正在将 Excel 工作表中的数据插入数据库。单个查询中的所有行。

我搜索并发现要在单个查询中插入多行我必须像这样进行查询

INSERT INTO table_name(c1,c2) VALUES( (value1,value2),(value1,value2))

这就是我的INSERT INTO查询对于单行的样子

INSERT INTO December_2015(S_No,Zone,State,City2,VM_Town,Distibutor_Code,Distributor_Name,Dealer_Code,Dealer_Name,Category,Address,Location,Contact,Mobile_No,Visit_1,Visit_2,Visit_3,Visit_4,Visit_5,Visit_6) VALUES(('1','South','Telanagana','Hyderabad','Y','1006704','Sai Santhoshi Enterprises','TG000999','Sree Laxmi Mobiles','A','F4,anthem Arcade,gujarathi Galli,koti ','Koti','Rajesh','8790575680','7-Nov','18-Nov','28-Nov','','',''))

当我要插入多行时，我的INSERT INTO 查询对于multiple rows 看起来像这样

INSERT INTO December_2015(S_No,Zone,State,City2,VM_Town,Distibutor_Code,Distributor_Name,Dealer_Code,Dealer_Name,Category,Address,Location,Contact,Mobile_No,Visit_1,Visit_2,Visit_3,Visit_4,Visit_5,Visit_6) VALUES(('1','South','Telanagana','Hyderabad','Y','1006704','Sai Santhoshi Enterprises','TG000999','Sree Laxmi Mobiles','A','F4,anthem Arcade,gujarathi Galli,koti ','Koti','Rajesh','8790575680','7-Nov','18-Nov','28-Nov','','',''),('2','South','Telanagana','Hyderabad','Y','1006704','Sai Santhoshi Enterprises','TG000997','National Marketing','C','Shop No:28,2nd Floor,anthem Arcade,Gujarati Galli,koti ','Koti','Ramesh','9989014926','7-Nov','18-Nov','28-Nov','','',''))

这就是为什么我的查询中有两个括号但它返回错误 Operand should contain 1 column(s) 到底是什么问题？

Answer 1

您不需要外部支架。只需将每条记录括起来。

INSERT INTO table_name(col1, col2, col3) VALUES (1,2,3), (4,5,6);