Sqlite: Difference between revisions
From DWIKI
mNo edit summary |
Tag: wikieditor |
||
| (3 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= | |||
==Show tables== | |||
.tables | |||
==Select all from table== | |||
select * from mytable; | |||
==Describe table== | |||
.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;
