SQLiteStudio is a DB manager for SQLite databases
SQLiteStudio is a Windows-base DB manager for SQLite databases
Questions tagged [sqlitestudio]
90 questions
0
votes
1 answer
default string value
I want to set default value for a varchar column in sqlite.
default value is a path like c:\log
but sqliteStudio don't allow me to add this and after C value rest of values
are in purple:
c:\log
how should I add this?
Reza Akraminejad
- 1,412
- 3
- 24
- 38
0
votes
0 answers
file is encrypted or is not a database - IsoStoreSpy, sqlitestudio, visual studio 2015
i create an app in windows mobile 10. i used isoStoreSpy tool to download file from mobile, and i used SQLiteStudio to edit it. And then, i upload it to mobile and error:
file is encrypted or is not a database
Hoai Truong
- 512
- 2
- 7
- 17
0
votes
2 answers
Where I can Find Android database file in my app?
I need to find the path that have the database of my application and I need to insert into my android database by SQLlitestudio.... please help
I'm using andriod Studio
thank you
Andrew Emad
- 277
- 3
- 13
0
votes
1 answer
Clear SQL database
I want to remove all entered data into my SQL database. I am using Python to handle all of the SQL statements from the program - however I did not make a backup of the clean database, and I want to clear all the records and reset primary IDs etc…
CrhonamO
- 25
- 4
0
votes
2 answers
[UPDATE]how to display your data in android listview
I'm using SQLiteStudio(v2.1.5) for fetching the data inside my database (dbName) and i have 1 table (tbl_Names) and put in android. Now In my database I have a two column id and name. In my database (dbName) I have input three name consist of…
code_gear
- 3
- 2
0
votes
2 answers
SQLite: result of mathematical operation always is a text
I created the following table:
CREATE TABLE test (a INT,b INT);
After I inserted some data:
INSERT INTO test VALUES(1,2);
When I execute this SELECT:
SELECT cast(b as real) as x, a * b as y FROM teste
the fields "x" and "y" return with…
MarceloSouza
- 429
- 5
- 10
-1
votes
1 answer
SQL GROUP BY vs AVG (Problem 25 of SQL Practice Problems Book)
The question is taken from problem 25 of SQL Practice Problems Book...
[Problem 25][1]
[1]: https://i.stack.imgur.com/fmJjs.jpg
High freight charges
Some of the countries we ship to have very high freight charges.
We'd like to investigate some…
Mir Ali
- 1
-1
votes
1 answer
SQLite (SQLiteStudio 3.3.3): select from hardcoded list of values
I need to select few constants as if it was a table. I found similar question for postgress:
Select hardcoded values without table
But it doesnt work with SQLite. This:
select * from (
values (1),(2),(3),(4),(5)
);
returns 1 5 times instead.
How…
Boppity Bop
- 9,613
- 13
- 72
- 151
-1
votes
1 answer
How can I get SqlLiteStudio to export to SQL file with tables in the correct order?
I have a relational SQLite database with tables accessing each other via foreign keys. When I use SqlLiteStudio "Export" to output to a new SQL file, it writes out SQL "CREATE" and "INSERT INTO" statements based on alphabetical order of table…
Mark Seagoe
- 480
- 8
- 15
-2
votes
1 answer
Update a new column based on existing an column's value
My database is called 'liquorsales' and contains information on liquor sales from Iowa. I'm using SQLiteStudio.
One of the columns is called 'category' and it contains a 7 digit number(datatype is INT) where I noticed a pattern.
Numbers that begin…
Marshall
- 11
- 3
-2
votes
1 answer
SQLiteStudio: Is there a way to match row values from one table to column headers in another?
Say I have Table1 that lists products and the quantities of the products being purchased, but the table does not have the price of the products for the specified…
FranB
- 11
- 2
-2
votes
1 answer
sqlite string equality with literal fails
I am working in SQLLite Studio and trying to find all rows with a given CUSIP. However, when I add "where cusip='00080010'", my query returns no results, despite that fact that I can see that the first row has that cusip.
I first considered that…
Kalev Maricq
- 617
- 1
- 7
- 24
-2
votes
1 answer
How to make password for the database so no one can access it?
I'm using qt c++ and SQliteStudio, I need a way to protect the database with a password so that nobody can access its content directly; editing should only be done through the program itself.
Zoro Allam
- 41
- 9
-2
votes
1 answer
SQLiteStudio : Problems With Views
I'm trying to build a database for personal use, and part of the db will store the data of addresses, and the way I have done it is this:
Table 1: Address (Line 1 & 2) -- foreign key ----> Postal Codes
Table 2: Postal Codes -- foreign key ---->…
Nader Belal
- 157
- 3
- 10
-3
votes
2 answers
Cant select dates in SQLite
The simplest query in the world isnt working in SQLite:
SELECT * FROM "events"
WHERE "date" >= datetime('2021-08-05T22:00:00') AND
"date" < datetime('2021-08-12T22:00:00');
The dates in the table as follows and I only receive last…
Boppity Bop
- 9,613
- 13
- 72
- 151