I’m running this part of a query on Postgres and it’s running fine But when I try to run it in SQLite, I get this error: near “~”: syntax error Do you have any idea how I can run this function in SQLite? Answer Actually, if you want columns that start with a digit, you can simply use: …
Tag: sqlite
Remove Null from For loop of ArrayList
I am currently converting an ArrayList to a String to send it to a DB so I can retrieve it on the other end and convert it back to an ArrayList later. My thought process is to convert it to a string …
Update all rows with different values. When where conditions differ
Apologies in advance for the confusing title, but couldn’t quite find the right way to summarize it in the title. I have a table in SQLite Studio with four columns ID, Name, Tm (which means team) and TmID (TeamID) and 326 rows Obviously the query above allows me to update each row where the team is R…
SQLite Database not getting updated
So Ive created an app where the user can input details about the movies he has watched such as name,cast,rating…ect and the details are stored in a database inside a table names which is initialized in the DataBaseHelper class as in the below segment of code Ive created a list view and displayed the nam…
Why am I getting insufficient parameters supplied to the command error?
I have trying to read a database and display it into a datagridview, but I keep getting the error, using Windows Forms and SQLite: That’s the code I’m using, but what is the issue? I have tried removing the concatenation, and I’ve tried changing the parameters method too: I tried with and without …
SQLite: How to avoid using two CTE when using CASE statement?
I have a table trx with following schema: where id is the transaction id and p_id the id of the person doing it. I need to query trx so I get a table that allows me to plot an histogram of frequencies of transactions, that means, I want to know how many p_id did only 1 transaction, how many did
How to merge in SQL when the key variable is repeated in one of the tables?
I have a dataset with two tables. In the first, I have information about workers and in the second about companies. Each worker has an ‘id’ of the firm to which he belongs. I would like to create a …
Database search results with context
I’ve built a system for archiving, aggregating, and indexing my IM history across different platforms (e.g. MSN Messenger, Hangouts, WhatsApp). The data is currently stored in an SQLite3 database, and relevant parts of the schema look something like this: There are also NOT NULL constraints on all colum…
How to join two tables and add a limit
Given two tables in a SQLite database, app_vendor app and I am trying to get 10 ‘names’ from ‘app’ (names of apps) for a given ‘vendor_id’ What am I doing wrong? Answer Your WHERE clause is in the wrong location. You can do: Result: See running example at DB Fiddle.
Finding the difference between two rows in SQL and assigning a numerical value to it (SQLite)
I have a table name login_time John 2021-01-02 08:10:52 John 2021-01-02 11:55:01 John 2021-01-04 17:36:22 Amy 2021-01-02 10:12:48 Amy 2021-01-06 11:22:41 Amy 2021-01-06 19:05:07 I want to add a usage_days column. If the same user login within the same day of his last login time, it is considered as the same d…