110 questions
0
votes
1
answer
69
views
Making Date in SQL between two dates
I'm working in DB Browser for SQLite, and have written a query:
SELECT "Trade Details 2".TRADE_TYPOLOGY,
"Trade Details 2".CONTRACT_ID,
DATE("Trade Details 2".START_DATE) as ...
- 133
0
votes
1
answer
60
views
IN statement in SQL only returns 1st value
I've written code in SQL to pull out the data from two separate tables and join them together. I'm trying to qualify my results with an IN statement, so that only trades with certain counterparties ...
- 133
0
votes
1
answer
29
views
Adding a single line of code deletes my entire table SQL
I'm attempting to fix some of the dates I have in my SQL table. For context, I joined the two tables, "Trade Details" and "Trade Details 2" together. One of the columns in "Trade Details 2" is "...
- 133
0
votes
4
answers
20k
views
Case When expression for Dates in SQL Query
I'm attempting to fix some of the dates I have in my SQL table. For context, I joined the two tables, Trade Details and Trade Details 2 together. One of the columns in Trade Details 2 is START_DATE ...
- 133
1
vote
1
answer
2k
views
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, ...
- 133
-1
votes
1
answer
40
views
SQLite Exists Database
I want to display all the data from my database created in DB Browser, but I get these errors. I cannot find a solution. Please help me, this is very important to my project. Maybe there's a typo ...
- 39
1
vote
1
answer
2k
views
18.04 ubuntu sqlitebrowser doesn't start
I'm new to ubuntu and I cannot make db browser to launch, it seems to me that i am missing libraries, but i don't know how to add them because I am a noob.
when i type sqlitebrowser in terminal I get:...
- 9
2
votes
2
answers
23k
views
How to connect to a protected Sqlite3 database with Python
I created a SQLite3 database and protected it with a password ("test") thanks to the application DB browser for SQLite.
In order to connect to my database via Python, I need to provide the password ...
- 599
0
votes
2
answers
2k
views
SQLite database shows question marks (???) instead of these Unicode characters (தமிழ்)
I imported a CSV file containing Unicode into an SQLite database but instead of seeing the text, all that I see are question marks. Like this, "???". The encoding is UTF-8 (I've mentioned below what ...
- 95
3
votes
2
answers
4k
views
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
- 33.7k