HySql supports inserting multiple rows simultaneously using extended inserts.
Posted by: Faisal Mansoor Mansoor Ahmed
Date: March 17, 2015 02:15PM

MySql supports inserting multiple rows simultaneously using extended inserts.

INSERT INTO the_table (col1, col2, ..., colN) VALUES
(v1, v2, v3, ..., vN),
(v1, v2, v3, ..., vN),
...,
(v1, v2, v3, ..., vN);

Is it possible to perform extended inserts with MySqlData using parametrized SQL. It looks like JDBC supports this scenario using PreparedStatements, does MySql.Data has similar functionality?


Thanks,
Faisal

Options: ReplyQuote


Subject
Written By
Posted
HySql supports inserting multiple rows simultaneously using extended inserts.
March 17, 2015 02:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.