This question appears to be slightly different from some of the other questions out there dealing with duplicates on a LEFT JOIN. Here's my situation: I have a list of datapoints associated with a meter. The datapoints are contiguous but…
Data: user_choices table id userid choices 1 3 1,2,3 2 55 5 3 783 2,6,7 4 45 1,4 5 5 1,2,3,4,5,6,7 How can I query this table to explode the choices column filtered only to show values 1 or 2…
If I run the folowing query in MySQL 8.0.28: SELECT 2 as "A A" UNION ALL SELECT 1 ORDER BY "A A" I get A A 2 1 If I run SELECT 2 as "A A" UNION ALL SELECT 1…
I have the following query: SELECT cpe.entity_id AS configurable_product_id, cpe.sku AS configurable_product_sku, GROUP_CONCAT(DISTINCT cpsa.attribute_id ORDER BY cpsa.attribute_id SEPARATOR ',') AS configurable_super_attribute_ids, cp.entity_id AS simple_product_id, cp.sku AS simple_product_sku, GROUP_CONCAT(cpei.attribute_id, '_', cpei.value ORDER BY cpei.attribute_id SEPARATOR ',') AS simple_product_super_attribute_values FROM catalog_product_entity AS…
I have to retrieve a list of postings, by one or more category IDs. I do not want to have duplicate postings in my results. I'm only interested in responses that directly relate, or can draw relations with MySQL 8…
I have a large table called uk that includes fields called CurrTime and EvName. Using the following query (extract below) I create a new field called StartTime that extracts the time from EvName (which is a MEDIUMTEXT field). I want…
I am attempting to run the same query multiple times on the same mysql 8 database and table. I need to carry out experiments to determine if tweaking the query and or table itself improves performance. However after the first…
I have a table that contains a month and a year column. I have a query which usually looks something like WHERE month=1 AND year=2022 Given how large this table is i would like to make it more efficient using…
I have a couple of docker containers for my Laravel 9 app (Nginx, PHP, MySQL, PHPMyAdmin, etc). I use spatie package to backup my database. I don't know how to set the path to the mysqldump file as it's in…
We see large gaps in primary key column with auto_increment in mysql 8.0.31 release version in multiple tables (with default - innodb_autoinc_lock_mode = 2 (“interleaved” lock mode)). Also I understand some smaller gaps can happen in this mode. We have…