平时记录:
txt类似这样的格式:
"440","广东省 ","00"
"320","江苏省 ","01"
"330","浙江省 ","02"
"370","山东省 ","03"
"350","福建省 ","04"
"420","湖北省 ","05"
"110","北京市 ","06"
"310","上海市 ","07"
"340","安徽省 ","08"
目标:转换成相应的数据库文件
命令:
进入目录,txt文件也放在该文件夹下
cd data/data/com.XXX.xxx/databases
sqlite3 mydata.db
//按照实际的字段
create table province(pcode text not null,pname text not null,_id text primary key not null);
//这里“,”是分隔符,替换成实际的
.separator ","
.import province.txt province
然后就转换成功啦
但是遇到一个问题,这样转换之后的第一个参数总会多两个双引号,目前不知道要怎么才能去掉,只能在使用的时候加一些处理。