From the following table of sport matches: id_ p1_id p2_id match_date p1_stat p2_stat 852666 1 2 01/01/1997 1301 249 852842 1 2 13/01/1997 2837 2441 853471 2 1 05/05/1997 1474 952 4760 2 1 25/05/1998 1190 1486 6713 2 1…
I have the following query: SELECT m.id_ AS match_id, mv.id_ AS match_version_id, t.id_ AS tournament_id FROM test.match_version AS mv JOIN test.match_ AS m ON m.id_ = mv.match_id JOIN test.tournament AS t ON t.orig_id = m.tournament_orig_id AND t.tour_id = m.tour_id ORDER…
We have a live MySQL server at the company where everything comes together. It was created around 1998 and has been running continuously ever since. The MySQL version is 3.51. WinMySQL version 1.4 from 2001. I was just born at…
I have a table like this: CREATE TABLE test( id INT AUTO_INCREMENT PRIMARY KEY, server_id VARCHAR(15) NOT NULL, secret_number INT NOT NULL, processing_status VARCHAR(15) DEFAULT 'UNPROCESSED', ts TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ); I want to get the SUM(secret_number) of…
I'm using MySQL 8.2 and I've got a table called records for which I added the following index in order to perform text search on it: CREATE FULLTEXT INDEX all_records_idx ON records (`title`, `label`, `description`, `catalog_number`,`barcode`); Now, I've got the…
I have a table that read day_sunday, day_monday, etc... So I need to check that for today's column if value is true then what data is stored. For example 17 may => Wednesday so the query will be select *…
I have an entry for 'joe'@'%' with the same password and the same mysql_native_password plugin on a MySQL 5.7 and MySQL 8 server for these tests. The "mysql" binary from MySQL 5.7 honours "-p" as expected when I want to…
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…