SQLite入门之三常用命令
来源：动视网
责编：小采
时间：2020-11-09 13:48:51
SQLite入门之三常用命令
SQLite入门之三常用命令:sqlite .mode csv sqlite SELECT * FROM Cars; 1,Audi,522 2,Mercedes,57127 3,Skoda,9000 4,Volvo,29000 5,Bentley,350000 6,Citroen,21000 7,Hummer,41400 8,Volkswagen,21600 sqlite .mode tabs sqlite SELECT * FROM Cars; 1 Audi 522 2 Mercedes 57
导读SQLite入门之三常用命令:sqlite .mode csv sqlite SELECT * FROM Cars; 1,Audi,522 2,Mercedes,57127 3,Skoda,9000 4,Volvo,29000 5,Bentley,350000 6,Citroen,21000 7,Hummer,41400 8,Volkswagen,21600 sqlite .mode tabs sqlite SELECT * FROM Cars; 1 Audi 522 2 Mercedes 57
sqlite .mode csv sqlite SELECT * FROM Cars; 1,Audi,522 2,Mercedes,57127 3,Skoda,9000 4,Volvo,29000 5,Bentley,350000 6,Citroen,21000 7,Hummer,41400 8,Volkswagen,21600 sqlite .mode tabs sqlite SELECT * FROM Cars; 1 Audi 522 2 Mercedes 57
sqlite> .mode csv
sqlite> SELECT * FROM Cars;
1,Audi,522
2,Mercedes,57127
3,Skoda,9000
4,Volvo,29000
5,Bentley,350000
6,Citroen,21000
7,Hummer,41400
8,Volkswagen,21600
sqlite> .mode tabs
sqlite> SELECT * FROM Cars;
1 Audi 522
2 Mercedes 57127
3 Skoda 9000
4 Volvo 29000
5 Bentley 350000
6 Citroen 21000
7 Hummer 41400
8 Volkswagen 21600
，
SQLite入门之三常用命令
SQLite入门之三常用命令:sqlite .mode csv sqlite SELECT * FROM Cars; 1,Audi,522 2,Mercedes,57127 3,Skoda,9000 4,Volvo,29000 5,Bentley,350000 6,Citroen,21000 7,Hummer,41400 8,Volkswagen,21600 sqlite .mode tabs sqlite SELECT * FROM Cars; 1 Audi 522 2 Mercedes 57
