将一个“单词表.txt(包含单词和意思)”导入到Android Studio中的SQLite中，要如何实现？

Question

刚接触SQLite，求指导。

Answer 1

It’s almost the same as mysql.

There is a sqlite3.exe command in the android sdk, which can directly operate the sqlite3 database.

Create database

create table xxx(word text, mean text)

If the file contains sql, use

.read sql文件

If the data is separated in the file, use

.separator 列分隔符 
.import 数据文件