Sqlite: Difference between revisions
From DWIKI
Created page with "=Links= *https://www.sqlitetutorial.net/sqlite-tutorial/ =FAQ=" |
Tag: wikieditor |
||
| (4 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 | |||
=FAQ= | =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; | |||
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;
