SQLite Queries

[autoitxp]

Hi i decided to share some usefull sqlite Queries to get date fast

To count all records :

select COUNT(*) from mytable;

To get singal row or many you want : best and very fast for me

SELECT * FROM  mytable ORDER BY rowid DESC limit 1  offset 0;

this will show 20 to 10 records order by ASC

SELECT * FROM  mytable ORDER BY rowid ASC limit 10  offset 20;

if you have any good queries to get data fast share it

Regards

Sim

Edited November 29, 2007 by autoitxp

[John117]

Heres a quick one resulting from some help from Psalty when I first started learning Autoit (Update Query)

$sExec = "UPDATE Users SET Department='Marketing' WHERE User_Name='" & $UserName & "'" ; Change a record
If _SQLite_Exec($hDB, $sExec) = $SQLITE_OK Then ConsoleWrite("Debug:  Successfully updated a record." & @LF)

Edited November 29, 2007 by Hatcheda