1. Save the data saved in Excel as csv format bookroom.csv Be careful not to bring the header, but only the data.

The exported data are as follows:

WenLiGuanLiuTongBu.png Art and Science Museum Circulation Department 3000 1

JingGuanYuanTuShuFenGuan.png Economic Management College Book Branch 30002

2. Use the import command of sqlite3 to import data from a file into a table. Before importing, you need to use the. Command, otherwise the default delimiter is vertical bar' |'.

Sqlite3 test. db

sqlite & gt。 Delimiter','

sqlite & gt。 Import bookroom.csvbbookroom

Format of import command:

Import < enter file name >? & lt insert table name >

3. In this way, the data is imported into the bookroom table, as shown in the following test.

sqlite & gt？ Library;