Sqlite: Difference between revisions

From DWIKI
Tony (talk | contribs)
Tag: wikieditor
Tony (talk | contribs)
mNo edit summary
Tag: wikieditor
Line 1: Line 1:
=Links=
=Links=
*https://www.sqlitetutorial.net/sqlite-tutorial/
*https://www.sqlitetutorial.net/sqlite-tutorial/
=Performance tuning sqlite=
TODO


=Cheatsheetje=
=Cheatsheetje=

Revision as of 10:56, 7 November 2025

Links

Performance tuning sqlite

TODO

Cheatsheetje

Show tables

.tables

Select all from table

select * from mytable;

Describe table

.schema mytable

FAQ

Check integrity

PRAGMA integrity_check;