How to insert data in batches in the SQLite database?

Welcome to the Oracle community forum and interact with 2 million technical staff to access the SQLite database. How can we efficiently insert batch data into the database? This article introduces this method. Let's take a look at it. The procedure is as follows: first, use Access to open the mdb file. Export to a txt file.

Welcome to the Oracle community forum to interact with 2 million technical staff> how can we efficiently insert batch data into the database in SQLite database? This article introduces this method. Let's take a look at it. The procedure is as follows: first, use Access to open the mdb file. Export to a txt file.

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

SQLite DatabaseHow to efficientlyBatch DataInsert to database? This article introduces this method. Let's take a look at it.

The procedure is as follows:

First, use Access to open the mdb file. Export to a txt file. Since SQLite is used in linux, the encoding must be changed to Unicode, And the separator should be separated by commas (,) to be imported to SQLite later)

Step 2: import the file to linux

Terminal

> Sqlite3 abc. db

SQLite version 3.6.22

Enter ". help" for instructions

Enter SQL statements terminated with ";"

Sqlite>

Enter a database that has been created


Sqlite> create table eee (id integer primary key,

Number NUMERIC, code NUMERIC, city TEXT, citytype TEXT );

Create a table whose fields and data types correspond to the data and data types in the txt file.


Sqlite>. separator "," // set the delimiter to comma, which is consistent with the delimiter set in the previous export.

Sqlite>. import list.txt eee // import the content on list.txt to the table eee

At this point, batch data has been successfully inserted into SQLite.

We will introduce the knowledge of the SQLite database here, and hope this introduction will bring you some gains.