I googled correlated subquery, and it gave me the below example. However, it appears in the outer query, that department id will be determined by a dynamic salary, which in turn, is determined by a relationship between department_id in the…
I got three data in MySQL [{"key": "field_1", "value": "test_1"}, {"key": "field_2", "value": "test_2"}] [{"key": "field_1", "value": "1"}, {"key": "field_2", "value": "test_2"}] [{"key": "field_2", "value": "test_2"}, {"key": "field_1", "value": "test_1"}] I need to search data which include "key" = "field_1"…
If I have two queries with the same field but different sort fields then, do I need to create a single compound index or multiple compound index with different sort fields? I am working on an e-commerce site, where I…
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 have multiple tables with the exact same structure (fields: date, id, revenue). Let’s imagine I have 3 tables, each one with 3 rows to make this simpler. The only thing that changes between each table the is the suffix,…
i want to add new enum values called "pending" to existing table so the enum will be ['paid', 'unpaid', 'pending', 'free'] the table on phpmyadmin so i try to define it on migration and i think it would automatically update…
So, I am doing union on same table, table1 with 2 different set of queries. My first query should return results with type 'test' and 2nd query should return results irrespective of type. But when Iam executing below query my…
I have a mysql event that is scheduled to run nightly defined as follows: create definer = myuser@`%` event nightly on schedule every '1' DAY starts '2023-10-21 00:00:00' enable do call mydb.nightly_script; Although when I look at the tables that…
I am trying to understand SQL better and have run into a problem when it comes to key-value pairs (I think there is a better term for this, but am not sure). Contract Contract Type Column1 Column2 Contract 1 Type…
Last Status Closed Applications User table 1: applications id(pk) name 1 naveed table 2: statuses id(pk) status application_id(fk) 1 pending 1 2 submitted 1 3 closed 1 4 observation 1 now i want to get list of applications if last…