I have a table listings with a jsonb column named data. Inside the data column I have the next structure { "attributes": { "listings": [ { "vin": "a", ... }, { "vin": "b", ... } ] } } I am…
The database used is PostgreSQL. I have a query that combines two tables and does a where search on some category and then does order by by some property. The table products has a 10+ million products. If I put…
I have a PostgreSQL table which gives me the following output: country metric_code male female pensioners teenagers us metric_1 10 14 22 30 us metric_2 105 142 222 309 uk metric_1 15 13 9 21 uk metric_2 212 264 440…
I want to use a column of arrays as a condition in postgres. The condition is applied on a column composed of text value. This is the column made out of arrays (after be transformed with string_to_array. And this is…
I have a table called phones with a column like this where items here are repeated brand Google Samsung Apple Hydrogen Nokia Itel Honor Huawei and I want to use either the LIKE keyword or the regular expression in MySQL…
I have a csv file which I loaded into MySQL after creating a database and a table (phones). The columns of the table among others are: state and phone_condition. Also, I have ran many queries which were successful; but this…
I'm adding data to a MySQL 8 database on PythonAnywhere. I'm doing this via a python 3.10 script run in VSCode using an SSH Tunnel. When I add the data it takes approximately 50 seconds to add 275 rows, data…
I have a search query where I am getting records from 2 tables Table A gives client data , Table B gives transaction number clientdid is PK in table A and FK in table B . I am using left…
How can I implement IGNORE NULLS in window functions such as FIRST_VALUE and LAST_VALUE in MySQL? For example, let's say we have a very simple table called sales. SaleID CustomerID SaleRegion 1 7 CITY A 2 10 NULL 3 10…
I have a table that stores member info. The column 'added' stores the date they joined. View Table I want to get the most recent dates in the added column and update them to a specific date. Sometimes it is…