我试图从一个逗号分隔的文件中加载数据。例子:
A,positive,9619
A095CDB461A1FEED,positive,1
当我试图在sqlite3数据库中加载此文件时,出现错误:
sqlite> .mode csv feature_category
sqlite> .import /home/harit/work/python/what-twitter-speaks/classifier/data/snap_data_collection/db-positiveTweets feature_category;
Error: no such table: feature_category;
尽管该表已经存在。
sqlite> select * from sqlite_master;
table|feature_category|feature_category|2|CREATE TABLE feature_category(feature, category, count)
table|categorycount|categorycount|3|CREATE TABLE categorycount(category, count)
请帮忙,我是新来的sqlite3
谢谢你