I have the following query: SELECT match_main.checked, match_main.match_main_id, match_main.updated, match_main.created FROM match_main LEFT JOIN match_team AS mt1 ON mt1.match_main_id = match_main.match_main_id AND mt1.team_number = 1 AND mt1.version_number = 0 LEFT JOIN match_team AS mt2 ON mt2.match_main_id = match_main.match_main_id AND mt2.team_number…
I'm having troubles with my MySql server. It's used mainly for storing production logs, but unfortunately it seems like it it too slow and i dont know if there is something i could do to improve it.Sometimes there is even…
I current use the numpy roots function as follows: y = numpy.roots([-2, 3, 0, -1 * x])[1] In the above x is a column in a table that I extract to run through the function. If possible I'd like to…
I'm not able to quite figure out how to capture the changes over time. I have the following: db<>fiddle CREATE TABLE term_changes (load_id int, merchant_id int, load_date date, terms varchar(50)); INSERT INTO term_changes (load_id, merchant_id, load_date, terms) VALUES (1, 1,…
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 *…