Sqlite: Difference between revisions
From DWIKI
mNo edit summary |
m (→Cheatsheetje) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 2: | Line 2: | ||
*https://www.sqlitetutorial.net/sqlite-tutorial/ | *https://www.sqlitetutorial.net/sqlite-tutorial/ | ||
=Cheatsheetje= | |||
==Show tables== | |||
.tables | |||
==Select all from table== | |||
select * from mytable; | |||
==Describe table== | |||
.schema mytable | |||
= FAQ = | = FAQ = | ||
Latest revision as of 16: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;
