I’m trying to write an SQLite query that would return a row, that would execute the following stat..
Tag : sqlite
Context: I have a table that has 3 columns: “day”, “arrivals”, “max_output_capa..
UPDATE ITEMS
SET ID_SECTION = (
SELECT B.ID_SECTION
FROM TT_ItemSection B
WHERE ITEMS.ID_ITEM = B.ID_ITEM AND B.IS_MAINSECTION = ‘Y’
);
how can i fasten this query. It is taking so much to execute (S..
I have 2 separate tables. I can’t seem to figure out a Select statement with a Join and Case condition that gives results based on changing account numbers. In Client_info table we have 6 digit account numbers which can now change to 7 or 8. Client Balance table is connected with Client Info via the acct_no field but the acct_no field here is a derivation of acct_no in Client info. In some cases, there are digits before and after the six digits. For ex..
When I try to insert a product from my ProductDetails table with seller_id from Sellers Table as its relationship, it says foreign key constraint f..
I need to merge some datasets and the tables need to match. The first one I did ..
Я делаю телеграмм бота, и мне нужно сохранять отправление пользователем фото, в таблицу SQLite 3, а потом обратно отправлять этому пользователю через метод SELECT, но у меня не получается, и программа не работает. Помогите пожалуйста вот ..
I have an 86GB SQLite database I am trying to rebuild using VACUUM. The problem is it appears to eventually load the entire database into memory to do this, and I only have 32GB of memory. I am on macOS, and the OS seems to not allow it to swap that much and the disk access is slowed to a few MB per second (down from nearly 1GBps at times during the initial part of the pro..
I have a table with a column price. I’d like to join this column the value above a threshold or below depending on what’s hit first.
For ins..
I have a NextJS app for which I want to cache data from our backend APIs. This cache would also have extra columns added to make things easier to lookup. Ideally this cache/database also supports join qu..