Skip to Content
0
Former Member
Oct 29, 2007 at 05:18 AM

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

138 Views

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.