Top "Sqlite" questions

How can I get dict from sqlite query?

db = sqlite.connect("test.sqlite") res = db.execute("select * from table") With iteration I get lists coresponding to the rows. …

python sql sqlite dictionary dataformat

How to get the total number of rows of a GROUP BY query?

From the PDO manual: PDOStatement::rowCount() returns the number of rows affected by the last DELETE, INSERT, or UPDATE statement …

php database sqlite pdo

Modify a Column's Type in sqlite3

I'm pretty new to SQLite 3 and just now I had to add a column to an existing table I had. …

sqlite alter-table

SQLite UPSERT / UPDATE OR INSERT

I need to perform UPSERT / INSERT OR UPDATE against a SQLite Database. There is the command INSERT OR REPLACE which …

database sqlite upsert

SQlite - Android - Foreign key syntax

I've been trying to get foreign keys working within my Android SQLite database. I have tried the following syntax but …

android sqlite foreign-keys

How to use SQL Order By statement to sort results case insensitive?

I have a SQLite database that I am trying to sort by Alphabetical order. The problem is, SQLite doesn't seem …

sql sqlite sorting sql-order-by

Sqlite in chrome

Is it possible to make chrome extension that interacts with sqlite database similarly as firefox extension? Could you give me …

javascript sqlite google-chrome-extension

SQLite table constraint - unique on multiple columns

I can find syntax "charts" on this on the SQLite website, but no examples and my code is crashing. I …

sqlite unique-constraint compound-key

CASE statement in SQLite query

Why this query doesn't work? :( I tried to replace nested IF statement "...SET lkey = IF(lkey >= 11, lkey - 5, IF(…

sqlite nested case

Execute SQLite script

I start up sqlite3 version 3.7.7, unix 11.4.2 using this command: sqlite3 auction.db where auction.db has not already been created. …

sqlite