111 questions
1
vote
1
answer
67
views
REGEXP in SQLite - problem while editing table
I started learning SqLite and encountered a problem with regular expressions. I use DB Browser. A table is created, the table has two fields: email and address. When writing the line "address&...
- 89
0
votes
0
answers
73
views
Open DB browser For SQLCipher by command line
We use SQLite and, more recently, the encrypted version with SQLCipher.
It works well with our software, but I'm having a small problem using DB Browser for SQLCipher. This software works well, but it ...
- 1
0
votes
1
answer
599
views
DB Browser for SQLite
I have installed DB Browser for SQLite on my mac. I need to create a SQLITE database or use an existing database and create a table in the database called "Ages":
CREATE TABLE Ages (
...
-1
votes
1
answer
51
views
Combining SELECT with SELECT DISTINCT in DBBrowser SQLite
I've got a query to select distinct results with two tables which returns email addresses that don't occur in table2, but I'm having trouble also selecting data from the Table 2.First in this query ...
- 1,695
0
votes
1
answer
45
views
Basic Join Query Not Yielding All Columns when using "Select *" [closed]
I'm taking a SQL Essentials training course. It's time to learn Joins and the instructor is having us use DB Browser. So far, everything has worked great; until this lesson.
The instructor has us make ...
- 17
0
votes
1
answer
49
views
Copy only the selected values form one table to another one with where clause in SQLite
I have a table with duplicated rows (table: electricity_meters). And there is another table (table: power_consumptions) that tells me which row of the first table to keep.
Trying delete the duplicated ...
0
votes
2
answers
73
views
How to control the frequency of sensors values being recorded in db browser SQLite?
I'm recording values of multiple mobile sensors in kotlin and storing them in DB Browser SQLite database. The problem I'm facing is that I'm getting too much values getting stored in database aprox ...
- 13
0
votes
1
answer
168
views
Extracting text in string using DB browser (SQLite)
I want to extract the \\xxxxxxx04\xxx and \\yyyy03\yyyyyyy from these samples:
\\\\xxxxxxx04\xxx\05. ***\*** **\*****\*****\****.pdf
\\\\yyyy03\yyyyyyy\***\*** **\*****\*****\****.html
There are ...
1
vote
0
answers
25
views
Adding a foreign key is not working in db browser for sqlite [duplicate]
ALTER TABLE employee ADD FOREIGN KEY(branch_id) REFERENCES branch(branch_id) ON DELETE SET NULL;
gives me following error message:
near "FOREIGN": syntax error
in line 12:
ALTER TABLE ...
- 11
0
votes
0
answers
245
views
Setting DB Browser (SQLite) application as a default app for opening .sqlite files for all users
I need to set DB Browser application as a default app for .sqlite files for all users.
I tried to set applicationn in windows settings for .sqlite files but it was set only for me.
Also I tried to ...
-5
votes
1
answer
265
views
How to get the day of the week from a date in mm/dd/yyyy format? [duplicate]
I am using DB Broswer for SQLite. I would like to retrieve information about the month and the day of the week for each sample.
SELECT Date
FROM Xtrain
returns
Date
26/04/2018
2/4/2018
I have tried ...
- 1
0
votes
0
answers
110
views
python saying table does no exist but the table is in DB browser
I am trying to make a search application connecting 4 databases but when I enter something in the input field. The application breaks
When I debug the application, it says 'MemberDetails' table does ...
- 1
-2
votes
2
answers
445
views
Can't import northwind sql file onto DB Browser for SQLite
I seem to get this error message.
[Error importing data: Error in statement #1: near "S":syntax error. Aborting execution and rolling back.]
(https://i.sstatic.net/IzRvb.png)
I looked into ...
0
votes
1
answer
254
views
Update year only in column timestamp date field SQLITE
I want to update the year only to 2025 without changing the month day and time
what I have
2027-01-01 09:30:00
2012-03-06 12:00:00
2014-01-01 17:24:00
2020-07-03 04:30:00
2020-01-01 05:50:00
2021-09-...
1
vote
1
answer
202
views
Choose encoding when converting to Sqlite database
I am converting Mbox files to Sqlite db. I do not arrive to encode the db file into utf-8.
The Python console displays the following message when converting to db:
Error binding parameter 1 - probably ...
- 21