Top "Sqlite" questions

How do I join two SQLite tables in my Android application?

Background I have an Android project that has a database with two tables: tbl_question and tbl_alternative. To populate …

android sqlite

How do i store and retrieve a blob from sqlite

I have used sqlite in c++, python and now (perhaps) in C#. In all of these i have no idea …

sqlite blob

How to do IF NOT EXISTS in SQLite

I am trying to port this line from MS SQL Server to SQLite IF NOT EXISTS(SELECT 1 FROM EVENTTYPE WHERE …

sql sqlite

sqlite3.OperationalError: unable to open database file

I get this error when setting up a server in Django. It is sqlite3 which means it should create the .…

python database django sqlite django-settings

How do I import .sql files into SQLite 3?

I have .sql files which have the following content: #cat db.sql create table server(name varchar(50),ipaddress varchar(15),id …

sql sqlite

Declare variable in SQLite and use it

I want to declare a variable in SQLite and use it in insert operation. Like in MS SQL: declare @name …

sql sqlite variables declaration

Sqlite convert string to date

I have date stored as string in an sqlite database like "28/11/2010". I want to convert the string to date. Specifically …

string sqlite date date-format

How do I UPDATE a row in a table or INSERT it if it doesn't exist?

I have the following table of counters: CREATE TABLE cache ( key text PRIMARY KEY, generation int ); I would like to …

mysql sql sqlite postgresql upsert

How do I use regex in a SQLite query?

I'd like to use a regular expression in sqlite, but I don't know how. My table has got a column …

regex sqlite query-string

SQLite select where empty?

In SQLite, how can I select records where some_column is empty? Empty counts as both NULL and "".

sql sqlite select isnullorempty