이런 것이 가능하다:
select '123'+1; -- 124
select '123'+'1'; -- 124
select 123 || 1; -- 1231
Datatypes In SQLite
1. Datatypes In SQLite Most SQL database engines (every SQL database engine other than SQLite, as far as we know) uses static, rigid typing. With static typing, the datatype of a value is determined by its container - the particular column in which the val
sqlite.org
심지어 any datatype도 있다.
STRICT Tables
1. Introduction SQLite strives to be flexible regarding the datatype of the content that it stores. For example, if a table column has a type of "INTEGER", then SQLite tries to convert anything inserted into that column into an integer. So an attempt to in
sqlite.org
'Programming' 카테고리의 다른 글
| [MySQL] ROWNUM을 사용하여 번호매기기 (0) | 2022.03.29 |
|---|---|
| How can I display MySQL query result vertically? (tutorialspoint.com) (0) | 2022.03.24 |
| SQL 툴 비교 (0) | 2022.02.16 |
| Import CSV File Into MySQL Table (mysqltutorial.org) (0) | 2022.02.15 |
| (Clojure) 후위 표기 계산기 (0) | 2021.12.16 |