1, will be stored in Excel in the data saved as a csv format bookroom.csv, pay attention to do not take the table header, as long as the data on the line.

After exporting the data are as follows:

30001,WenLiGuanLiuTongBu.png

30002,JingGuanYuanTuShuFenGuan.png

2, the use of sqlite3 import command to import the data from the file to the bookroom. command to import the data from the file to the table, before the implementation of import need to use the .separator command to set the data separator comma, otherwise the default separator symbol is the vertical line '|'.

sqlite3 test.db

sqlite> .separator ','

sqlite> .import bookroom.csv bookroom

Format of the import command:

import < ;input filename> ? <insert table name>

3, so the data is imported into the bookroom table, the following test.

sqlite>? bookroom;