Sqlite: Difference between revisions
From DWIKI
mNo edit summary Tag: wikieditor |
Tag: wikieditor |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
=Links= | =Links= | ||
*https://www.sqlitetutorial.net/sqlite-tutorial/ | *https://www.sqlitetutorial.net/sqlite-tutorial/ | ||
=Performance tuning sqlite= | |||
TODO | |||
=Cheatsheetje= | =Cheatsheetje= | ||
==Show tables== | |||
.tables | |||
==Select all from table== | ==Select all from table== | ||
select * from mytable; | select * from mytable; | ||
| Line 8: | Line 13: | ||
==Describe table== | ==Describe table== | ||
.schema mytable | .schema mytable | ||
==Describe all tables== | |||
.schema | |||
= FAQ = | = FAQ = | ||
Latest revision as of 12:27, 28 January 2026
Links
Performance tuning sqlite
TODO
Cheatsheetje
Show tables
.tables
Select all from table
select * from mytable;
Describe table
.schema mytable
Describe all tables
.schema
FAQ
Check integrity
PRAGMA integrity_check;
