Linked Questions

My Django project uses an SQLite3 database. How can I get to the SQLite command line shell? PyCharm has lots of other handy interactive windows manage.py utility console Python console sqlite3> ??...

I have found the solution to get all tables in SQLite here. How to list the tables in an SQLite database file that was opened with ATTACH? However, when I change: SELECT name FROM sqlite_master ...

We are creating a WinStore application using C# that stores some data locally within a SQLite database. We are currently using the SQLite-net library to access the database. There are a number of ...

Here is my code snippet:- import sqlite3 database = "sample.db" def dbConnection(database): try: connection = sqlite3.connect(database) db_cursor = connection.cursor() ...

I have created a database for username and password, it worked fine when I was at my other computer now on this computer I get the error that the table does not exist, I can't understand why it is not ...

I have tried to get the table names from android mobile programmatically using the following code: Cursor tableCursor = getContentResolver().query(Uri.parse("content://telephony/sqlite_master"),new ...

I have an SQLite database made using the SQLite port in Sencha Touch (here) and the database name is "cars" without the quotes and the table inside it is called "cars_table" without the quotes. I am ...

I have a directory with lots and lots of SQLite database files. I need to run an sqlite3 query to establish if any database in my directory contains a specific table. Database filenames go like 001....

I'm using sqlite manager extension in chrome to use sqlite database.I have a sqlite database.This extension works properly with select delete alter commands.but the problem is i can't list tables of ...

This question is a spin off a previous question here in which a database was created. However, when it comes to add information to that dataset I can go manually adding information or going via a ...

I want to use SQLite in memory mode, and load a DB file that is stored inside the jar. Seems like SQLite can't find/load the file. Here's my code: String dbpath = Resources.getResource("my-db.dat")....

I'm developing a Rust application for user registration via SSH (like the one working for SDF). I'm using the SQLite3 database as a backend to store the information about users. I'm opening the ...

I'm try get name of tables in sql expression using sqlite3 API. Example: select * form table1, table2, table3; Sqlite3 API only return data of statment and only have information of name of columns ...

i'm working on a school project and i'm building a little server in NodeJS for our project, one of my tasks is to find a way to get the tables name of all "user"tables in the selected ...

I'm using a premade database and I seem to be getting an error when I try to update a row. The exact error from logcat is: (1) no such table: AUD. Heres what my dbhelper class looks like: public ...