Sqlite: Difference between revisions
From DWIKI
mNo edit summary |
mNo edit summary |
||
| Line 2: | Line 2: | ||
*https://www.sqlitetutorial.net/sqlite-tutorial/ | *https://www.sqlitetutorial.net/sqlite-tutorial/ | ||
=Cheatsheetje= | |||
==Select all from table== | |||
select * from mytable; | |||
==Describe table== | |||
.schema mytable | |||
= FAQ = | = FAQ = | ||
Latest revision as of 17:25, 25 March 2025
Links
Cheatsheetje
Select all from table
select * from mytable;
Describe table
.schema mytable
FAQ
Check integrity
PRAGMA integrity_check;
