Sqlite: Difference between revisions
From DWIKI
mNo edit summary Tag: wikieditor |
Tag: wikieditor |
||
| Line 3: | Line 3: | ||
=Cheatsheetje= | =Cheatsheetje= | ||
==Show tables== | |||
.tables | |||
==Select all from table== | ==Select all from table== | ||
select * from mytable; | select * from mytable; | ||
Revision as of 14:34, 14 April 2025
Links
Cheatsheetje
Show tables
.tables
Select all from table
select * from mytable;
Describe table
.schema mytable
FAQ
Check integrity
PRAGMA integrity_check;
