Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- lab-1:/etc/scripts# sqlite3 test.db
- SQLite version 3.8.10.2 2015-05-20 18:17:19
- Enter ".help" for usage hints.
- sqlite> .mode csv ;
- sqlite> .import /tmp/test.csv users
- sqlite> select * from users;
- John,Doe,au,0,"",1,5555,91647fs59222,audio
- sqlite> .quit
- lab-1:/etc/scripts# sqlite3 test.db ".mode csv ; .import /tmp/deleteme.csv users"
- lab-1:/etc/scripts# sqlite3 test.db ".mode csv .import /tmp/deleteme.csv users"
Add Comment
Please, Sign In to add comment