I have the following SQL statement: SELECT DISTINCT e.eventid, e.objectid, e.clock, e.ns, e.name, e.severity FROM events e, functions f, items i, hosts_groups hg WHERE e.source = '0' AND e.object = '0' AND NOT EXISTS (SELECT NULL FROM functions f, items…
here are my tables: products table: CREATE TABLE `products` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `description` text NOT NULL, `price` decimal(15,2) NOT NULL, `total_profit` decimal(15,2) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT…
I have a MySQL table with two columns, row1 and row2, and theese columns together increased. +------+------+ | row1 | row2 | +------+------+ | 10 | 100 | | 11 | 110 | | 20 | 200 | | 21…
I have a table with columns in jsonb format which contains data like this: ['A', 'B', 'C'] I want to convert column to array column type but I don't know how to do it properly. Example of my script structure:…
I have db on MySQL - dataset with users actions logs. We have next data collection logic - every user have it own user_id and we record log of event actions during user session. user_id session_id dateTime event 1 aa…
How to get record if createdDate is from one year later using sequelize userId createdDate 1. 2023-07-19 00:49:59 2. 2022-08-20 00:49:59 Tried return this.findAll({ createdDate: { [Op.gte]: new Date(new Date().getFullYear(), 1) } }); Expected Record 2. 2022-08-20 00:49:59
The table is called "process_flows" and the column of interest is called "results" Process_flows Table: contact_uuid result 2f12c383-e131-4454-8713 see text below The result column contains a nested json that looks like the sample below: { "assessment_dialog": { "name": "Assessment Dialog",…
I have the following query: SELECT * FROM customers_cards WHERE id NOT IN ( SELECT card_id FROM customers_card_psp) It takes about 2sec to get executed and we need this query to get called on a highly visited page. Any idea…
Lets say I have a table T1. Initially it has ID, Identifier, C1, C2 as columns. As time goes by I will be adding new columns C3, C4 and so on. Will it be better to have the columns as…
I am using postgres and I have multiple entries of jsonb inside an array in a single column called observation. They're input as '[{"a": 1}, {"b": 2}, {"c": 0.5}]'::jsonb. There are multiple rows, with multiple json elements inside of each…