how to insert multiple rows in a single insert statement in MaxDB?

[Former Member]

hi,

I was looking at syntax but i could not get it right.. may be some could help me.

// Insert single row works fine

INSET INTO test_table(column_name) values (value1) IGNORE DUPLICATES

// Insert multiple rows, doesn't

INSET INTO test_table(column_name) values (value1), (value2), (value3) IGNORE DUPLICATES

Can somebody help me with this.

thanks,

sudhir.

[TTK]

Multiple inserts do only work with parametrized statements, usually used in interfaces like JDBC, ODBC etc.

With static SQL statements it is not possible.

Regards Thomas