Hi,

I'm trying to insert multiple columns in a table in the following format
Code:
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'))
and getting the following exception in JSP
java.sql.sqlexception insert operand should contain 1 column(s)

Please help.