Stack Overflow
Stack Overflow

Questions tagged [db-browser-sqlite]

89 questions
4
votes
2 answers

How to fix empty string while fetching it from Database?

I am fetching a string from Database using the column id. When I enter a query in SQLite DB Browser it returns what is need but the same query returns nothing when coded through Java. My Data Base contains a table named drugs which has 3 columns…
Huzaifa Asif
  • 526
  • 5
  • 21
3
votes
0 answers

Create a encrypted SQLite database with C# EntityFramework and open with Database Browser for SQLite

I have created an encrypted SQLite database using C# EntityFramework but I'm not able to open it using DB Browser for SQLite DB Browser for SQLite is updated at the latest version 3.11 and I'm using DB Browser (SQLCipher) using…
Cyr
  • 353
  • 6
  • 15
2
votes
3 answers

Nesting queries

My query from the attached schema is asking me to look for the same location of where the people who tested positive went and were in the same people as the untested people. (Untested means the people not there in the testing table. --find the same…
Vij
  • 59
  • 5
2
votes
2 answers

IF ELSE Condition in SQLite

I am new to SQLite. I am looking for IF ELSE in SQLite to perform UPDATE OR INSERT operation based on the condition check. What I tried is: IF EXISTS(SELECT 1 FROM TblTest WHERE ID = 1 AND Name = 'XYZ') BEGIN END UPDATE TblTest SET Address =…
MAK
  • 5,596
  • 16
  • 61
  • 105
2
votes
0 answers

How do I refresh sqlite database in SQLite Database Browser?

I am using python to connect and make changes with a sqlite database. On the side, I am viewing the tables and database structure of the sqlite db using DB Browser for SQLite. After I run my python code and make changes, I normally have to close…
KubiK888
  • 3,525
  • 10
  • 49
  • 89
2
votes
1 answer

Database file loaded in the wrong encoding: 'UTF-8'

I know there are two similar questions asked about this issue, but both questions did not receive any explicit solutions. I have also tried the solutions mentioned but none solved mine. My issue is that I have a database created (using DB Browser…
user10504780
2
votes
1 answer

How do I set a PK:FK relationship in DB Browser for SQLite?

I'm in DB Browser for SQLite and I don't see any way to set a PK:FK relationship. Can it do that? thanks - dave
David Thielen
  • 22,779
  • 27
  • 83
  • 163
1
vote
1 answer

What causes a foreign key mismatch error in sqlite database

this is my student_table create query CREATE TABLE "student_table" ( "student_id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" TEXT NOT NULL, "gender" TEXT NOT NULL, "year_admited" INTEGER ); this is for my…
eliHeist
  • 29
  • 3
1
vote
4 answers

Why are no rows returned in my app, whereas the same query returns rows in DBBrowser?

With this simple query against my SQLite database: SELECT MovieTitle, MPAARating, IMDBRating, DurationInMinutes, YearReleased, genres, actors, directors, screenwriters FROM MOVIES_SINGLETABLE WHERE IMDBRating >= @IMDBMinRating ORDER BY…
B. Clay Shannon
  • 1,055
  • 124
  • 399
  • 759
1
vote
2 answers

How to open a database encrypted with SQLCipher?

I created and encrypted a database with the package.(react-native-sqlcipher) I want to open this database with "DB Browser for SQLite" or "SQLite Studio". However, it doesn't open even though I enter the correct key. Is salt being added while…
ertandrn
  • 31
  • 3
1
vote
1 answer

How do I open a sqflite database file in DB Browser for SQLite?

I have a Flutter/Dart application that I am coding using Android Studio. I use a database called envirodatabase.db with the sqflite package. I want to open the database in DB Browser for SQLite on my computer, but the only way it lets me do that is…
Marvin
  • 780
  • 10
  • 32
1
vote
1 answer

Foreign Key Constraint Failed - Even when I try to manually add data

I am studying SQL in my data science degree program, and the assignment is to perform SQL queries for the first time. In order to do that, I have to paste the SQL starter code in and run it. However, when I do, I hit an error that I can't solve. …
Michael Martin
  • 35
  • 7
1
vote
2 answers

SQlite DB BRowser - Create users in auth_user table by SQL - how to hash password?

Maybe I am doing something wrong but I would like to create data for my Django app tests and first, I would like to create users using sql script in DB Browser SQLite INSERT INTO auth_user (date_joined, username, first_name, last_name, email,…
SLATER
  • 431
  • 3
  • 12
1
vote
1 answer

How to add bulk values in column using DB Browser SQLite

I have a table that contain two columns. One column "rewords" contain 12186 words. and the other column named "ID" is the column that I newly created so it is empty. I want to add numbers against the rewords column. numbers from 1, 2, 3, to 12186. i…
Surraya Marvi
  • 111
  • 9
1
vote
1 answer

Disk I/O Error when importing from SQL into python

import sqlite3 import pandas as pd slice3_path=r"F:\GM RWA\Database\Wild.sql" conn = sqlite3.connect(slice3_path) sql='''SELECT DOG, CAT, TIGER FROM (SELECT * FROM "Mammals") GROUP BY DOG, CAT, TIGER ORDER BY TIGER asc''' df = pd.read_sql(sql=sql,…
throway172
  • 93
  • 2
  • 11
1
2 3 4 5 6