livedoorクリップとSQLite3
livedoorクリップをSQLite3に読み込む
cat clip.org.csv | sed -e 's/^\"//g' | sed -e 's/\"$//g' > clip.csv
create_cliptable.sql
-
- -
create table clip (
user_id int not null,
url varchar(255) not null,
timestamp timesatmp,
tags text
);
-
- -
sqlite3 clip.db < create_cliptable.sql
sqlite3 -separator \",\" clip.db ".import clip.csv clip"