[RESOLVED] operand should contain 1 column(s) for INSERT statement
I'm trying to insert multiple columns in a table in the following format
and getting the following exception in JSP
INSERT INTO table_name (column1, column2, column3) VALUES ((123, 'abc', 'abc'), (123, 'abc', 'abc'), (123, 'abc', 'abc'), (123, 'abc', 'abc'), (123, 'abc', 'abc'), (123, 'abc', 'abc'))
java.sql.sqlexception insert operand should contain 1 column(s)
I don't think you want the extra pair of parentheses wrapping the rows to be inserted.
... VALUES (a,b,c), (d,e,f),(g,h,i)
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
How to Ask Questions the Smart Way
(not affiliated with this site, but well worth reading)
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread