Menu
How we can insert multiple rows in Sqlite database at same time? I'm using Android with Java.
439
INSERT-SELECT-UNION query to insert multiple records Thus, we can use INSERT-SELECT-UNION query to insert data into multiple rows of the table. The SQL UNION query helps to select all the data that has been enclosed by the SELECT query through the INSERT statement.
Answer. Yes, instead of inserting each row in a separate INSERT statement, you can actually insert multiple rows in a single statement. To do this, you can list the values for each row separated by commas, following the VALUES clause of the statement.
The steps to insert multiple records to a table are: Prepare the connection to the database and then get a cursor. Get all your records to a list. Use executemany() method and pass the query and records list as arguments to the method.
Python Insert multiple rows into SQLite table using the cursor's executemany()
you can use inserthelper, check this blog
105
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
