Questions tagged [db-browser-sqlite]

104 questions
0
votes
1 answer

SQL Dates and Time Formatting

got a quick question on some SQL formatting. I am struggling figuring out how to make the formatting for a table the same. The table includes about 15 years worth of data. Most of the time stamps are formatted in a similar way. They are in columns…
0
votes
1 answer

Can I add a note to the SQLite table design using DB Browser for SQLite?

Is there a possibility to add notes in DB Browser for SQLite to annotate the table?
Dr.D
  • 23
  • 3
0
votes
0 answers

Getting a foreign key constraing when trying to insert row into DB Browser

I have created the following tables with JS: const sqlite3 = require('sqlite3'); const db = new sqlite3.Database('./database.sqlite'); db.serialize(function() { db.run('CREATE TABLE IF NOT EXISTS `Artist` ( ' + '`id` INTEGER NOT NULL, '…
Irins
  • 1
  • 1
0
votes
3 answers

Is there any command to execute SQL and cut a last words in row of database?

I'm importing a database to DB Browser SQLite and need to execute SQL and cut a last words include '-' as in red circle for all rows under 'slug' in database. Is there any command to do these? Thanks
user2971638
  • 477
  • 1
  • 4
  • 12
0
votes
2 answers

index list view with database cardview

I know there are alot of duplicates with issues like these but pleas do read mine and help me out. I am very new to Android development as such I coded these with my own instincts and limited guides available. I'd like to implement an indexable…
user10504780
0
votes
0 answers

click related keyword like a search input

Hi sorry for my bad title (i really dont know how to phrase it better) but i have a cardview just like this cardview where the result/s returned are based on the user has input on the search bar. All of the information returned are based on my…
user10504780
0
votes
0 answers

SQLITE escape comment "--"

I'm using DB Browser for SQLite, doing multiple inserts. However I need to escape -- but it just keeps giving me errors. INSERT INTO table(name) VALUES ("S6--sfI6H6E"),("ASGts7sa6jw") -- Error at S6 I have tried the following: INSERT INTO…
mt025
  • 273
  • 4
  • 13
0
votes
1 answer

SQLite3: Recovering database from "Invalid file format"

After a power surge got my SQLite3 database corrupted "the hard way". Trying to open it in DB Broweser for SQLite gives: Invalid file format. How to recover?
Denis Kulagin
  • 8,472
  • 17
  • 60
  • 129
0
votes
1 answer

Annoying error when trying to run SQL exported from db browser for sqlite

I am simply trying to run a basic SQL script to recreate a database. The database was initially created in SQLite, and I exported it using DB Browser for SQLite. The start of the file looks like this: BEGIN TRANSACTION; CREATE TABLE "AspNetUsers"…
Bassie
  • 9,529
  • 8
  • 68
  • 159
0
votes
0 answers

Correct SQL Statement for duplicating items with special scenario

All check items in the picture must be shown. Here is my sql statement. SELECT DISTINCT c.code || ' - ' || c.description || ' - ' || s.num AS SearchColumn, s.num AS Num, c.code AS Code, c.product AS Product, f.faciltyname AS…
0
votes
1 answer

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 START_DATE, DATE(substr("Trade Details…
throway172
  • 123
  • 2
  • 4
  • 12
0
votes
1 answer

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 show up. SELECT "Trade Details 2".Portfolio,…
throway172
  • 123
  • 2
  • 4
  • 12
0
votes
1 answer

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 "START_DATE" with dates ranging back to the early 2000's…
throway172
  • 123
  • 2
  • 4
  • 12
0
votes
3 answers

Case When statement 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" with dates ranging back to the early 2000's…
throway172
  • 123
  • 2
  • 4
  • 12
0
votes
2 answers

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 happened when I tried UTF-16). The SQLite manager…
Dan
  • 95
  • 11