SQLite入门之二常用命令(三)

2014-11-24 10:16:05 · 作者: · 浏览: 2
l wirelessqa.db "SELECT * FROM Cars;"> wirelessqa.html
导出csv格式
bixiaopeng@bixiaopeng db$ sqlite3 -csv wirelessqa.db "SELECT * FROM Cars;"> wirelessqa.csv
bixiaopeng@bixiaopeng db$ cat wirelessqa.csv
1,Audi,52642
2,Mercedes,57127
3,Skoda,9000
4,Volvo,29000
5,Bentley,350000
6,Citroen,21000
7,Hummer,41400
8,Volkswagen,21600