首页 >数据库 >mysql教程 >SQLite入门之三常用命令

SQLite入门之三常用命令

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB原创
2016-06-07 16:20:03976浏览

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

声明:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn