Can you help me plase ? I want a result like the table below with Sqlite . task_name status_code department 1 A START PUR 2 B START ENG 3 C FINISH ENG 4 D NOT
I'm trying to use INSERT statement to add values to a few columns in a new table depending on the value of a column in another table. I'm writing in SQLite. I w
I need to create a new column in my dataset (duplicate_name) that contains TRUE if there are more than one record for someone or FALSE otherwise. I found this c
I have an ASP.NET Core 2.0 app using Entity Framework Core and the SQLite Provider. I am trying to store the SQLite database file in a subdirectory (specificall
I have simple entity @Entity() export class File { @PrimaryGeneratedColumn() id: number; @Column({type: "mediumblob"}) data: Buffer; } Which
I have a table called jobs with a column called job_num. How do i return the maximum value of the integers in that column? I have tried result = Job.select(m
I have found most people solved this issue simply by cleaning and re building their flutter databses by handling migrations in Moor. However, I have done the sa
I have an SQLite 3 database in SUSE Linux. It's stuck at the command prompt like so: sqlite> q ...> exit ...> .exit ...> quit ...> .q
I'm really having trouble trying to understand SQLAlchemy so I apologize if this is a really symplistic problem. I can't find the sqlite database in any of my d
In Django, I've added some models into models.py. After manage.py makemigrations, manage.py migrate raised this exception: django.db.utils.OperationalError: no
I have an inventory management app (windows) that uses sqlite3 database. The app is installed on the main PC we have in the office. I am going to have around 6
I am a beginner making use of a Roomdatabase. Mostly using it to load in and pass items between tables using simple relationships. package com.example.allin
I'm trying to export a dictionary of words in sqlite made up only of words that start with, contain, or end with specific filters. If one filter was 'ment' and
I am working on android project. In my project I have a 'DatabaseFood .sql 'file(initially it was a .csv file), it looks like this BEGIN TRANSACTION; CREATE TA
I am getting an SQLite Error 14: 'unable to open database file' with EF Core code first, no idea why. I worked fine the first time, the database file got crea
What is the equivalent of SQLite's IFNULL() in Postgres? I have to following query (sqlite in Ruby): SELECT ifnull(max(code_id) + 1, 1) FROM configentries W
I have a simple sqlite3 function from sqlite3 import connect def foo(name): conn = connect("data.db") curs = conn.cursor() curs.execute(f"CREATE T
Android, SQLite : I want to insert rows in between other rows in myTable using SQLite in android. For this, I am trying to increment ids of the all rows startin
I'm trying to populate a PrimeReact Tree with data from sqlite3 database, but it doesnt work. Here is my SQL-Query: select 'prj:'||p.id as key,p.name as label,(
I have an SQLite database that I am using with jOOQ. When I use jOOQ's code generation tool, it builds all of the table and record classes as expected. However,