New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

sqlite #174

Open

magicdawn opened this issue Mar 19, 2024 · 2 comments

Owner

magicdawn commented Mar 19, 2024

No description provided.

Owner Author

magicdawn commented Mar 19, 2024

SQLite

引号

'string value' 单引号表示一个字符串
"column" 双引号和 backstick 表示 identifier

https://www.sqlite.org/lang_keywords.html

与 `NULL` 比较

比如一个 deleted BOOLEAN 列, 值可选为 NULL | FALSE | TRUE

where deleted IS NOT TRUE: ✅ NULL, ✅ FALSE, ❌ TRUE

IS / IS NOT 会考虑 NULL 值

Owner Author

magicdawn commented Mar 19, 2024

SQLite json

`json_extract`

json_extract(column, '$.a.b.c')

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment