Sqlite: Difference between revisions

From DWIKI
(Created page with "=Links= *https://www.sqlitetutorial.net/sqlite-tutorial/ =FAQ=")
 
mNo edit summary
 
(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/


=FAQ=
=Cheatsheetje=
==Select all from table==
select * from mytable;
 
==Describe table==
.schema mytable
 
= FAQ =
 
==Check integrity==
 
PRAGMA integrity_check;

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;