欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

SQLite入门之三常用命令

程序员文章站 2022-05-15 08:37:48
...

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