I'm not sure if "dynamic table namespaces" is the correct way to describe what I'm looking for. I am developing a web app which will be used by an indefinite amount of clients. Nearly every table has a clientId to…
Let's say I have a table that has 3 fields: (id, name, points). Now initially I want to order them by points and also get the position. So here's my current query that does this: SELECT id, name, points, ROW_NUMBER()…
I have a database table named order_data that contains data like this: id order_id data_value data_key 9825 1156 2023-05-15 date 9826 1156 123 product_id Each order (order_id) generates these rows, so there can be multiple rows in this table which…
I have a simple table with an index on the count column | Counts | CREATE TABLE `Counts` ( `id` bigint NOT NULL, `count` int NOT NULL, PRIMARY KEY (`id`), KEY `count_i` (`count`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci | INSERT…
I have two tables named User and Payment. Where in Payment there is a foreign key of the user table. and here are the records of the Payment Table. SELECT id,User_id FROM payment; id User_id 1 1 2 1 3…
I have two tables device_part: device_id part_id software_version jdvjdksfks 1 v1 jdvjdksfks 2 v2 peirizkdsf 1 v1 peirizkdsf 2 v3 strategy_part: strategy_id part_id source_version target_version 1 1 v1 v3 1 1 v2 v3 1 2 v2 v3 2 3 v1…
I have a table (let's say, prod_config) with the below data- Prod_Id Config_Id Config_Type 9856 1 2 9855 93 1 9855 92 2 9855 91 2 9854 93 1 9854 92 2 9854 91 2 9849 93 1 9849 92…
I have a Laravel controller and here is a piece of my code for the SQL query that I made: $query = <<<SQL SELECT day, date, product1_shift1, product1_shift2, product1_shift3, COALESCE(product1_shift1, 0) + COALESCE(product1_shift2, 0) + COALESCE(product1_shift3, 0) AS total_product1_qty FROM…
I have the following MySQL query that pulls back 400 records: SELECT email FROM user WHERE email LIKE 'GMSD%@law.com' Returns: [email protected] through [email protected] What I want to do is remove the K from all 400 of these e-mail addresses in…
Trying to get an average of number from a table based on the latest dates of each. It works, but really slow, 30 seconds. Main table has 5,782 rows, and is growing. Anyway to change this query and make it…