[SQL] SQLite3 기본 설정 옵션

SQLite를 그냥 실행하면 알아보기 어렵다.

C:\Users\CREBAN>sqlite3 foods.db

SQLite version 3.41.0 2023-02-21 18:09:37
Enter ".help" for usage hints.

sqlite> select * from foods limit 1;
1|1|Bagels

sqlite>

기본적인 옵션은 다음과 같이 한다.

.echo on

.mode column

.headers on

.nullvalue NULL

 

C:\Users\CREBAN>sqlite3 foods.db
SQLite version 3.41.0 2023-02-21 18:09:37
Enter ".help" for usage hints.

sqlite> .echo on
sqlite> .mode column
.mode column
sqlite> .headers on
.headers on
sqlite> .nullvalue NULL
.nullvalue NULL
sqlite>

sqlite>

sqlite> select type_id, count(type_id) from foods group by type_id;
select type_id, count(type_id) from foods group by type_id;
type_id  count(type_id)
-------  --------------
1        47
2        15
3        23
4        22
5        17
6        4
7        60
8        23
9        61
10       36
11       16
12       23
13       14
14       19
15       32
sqlite>

SQLite3 기본 옵션 설정 적용 화면