SQLite入门之三常用命令

sqlite .mode csv sqlite SELECT * FROM Cars; 1,Audi,52642 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 52642 2 Mercedes 57

sqlite> .mode csv

sqlite> SELECT * FROM Cars;

1,Audi,52642

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    52642

2   Mercedes    57127

3   Skoda   9000

4   Volvo   29000

5   Bentley 350000

6   Citroen 21000

7   Hummer  41400

8   Volkswagen  21600