Count the highest group_id for each user as a distinct value

There's some tricky logic in my latest project (at least for me) and I've been trying to use HAVING to solve i...

From [MySQLdiscussion group] 2024-01-16 17:59:12 0  1  378

The department with the lowest average salary will receive a 10% salary increase

This interview question solution does not work because I have two columns in the subquery and if I use IN inst...

From [MySQLdiscussion group] 2024-01-16 16:43:12 0  1  411

MySQL constrains unique index only if another column is empty

I'm trying to rewrite the Postgres schema to fit the MySQL (8.0.32) dialect. As you know, MySQL does not suppo...

From [MySQLdiscussion group] 2024-01-16 15:42:42 0  2  470

How WordPress uses meta queries to query across multiple post types

I've encountered three rather complex problems. First, I have two custom post types: one for departments and o...

From [MySQLdiscussion group] 2024-01-16 15:52:53 0  1  402

Rewrite the title as: How to convert WITH `cte` AS (VALUES ROW(1), ROW(2), ROW(n)) in MySQL syntax to jOOQ DSL

I have a SQL query for MySQL: WITH`cte`AS((SELECT1431655747AS`n`FROMDUAL)UNIONALL(SELECT1431655733AS`n`FROMDUA...

From [MySQLdiscussion group] 2024-01-16 14:51:40 0  1  365

NodeJS Promise returns undefined value under random circumstances

First of all, I'm sorry if this question already has an answer, but I've searched for this kind of question an...

From [MySQLdiscussion group] 2024-01-16 14:46:41 0  1  429

"Uncaught mysqli_sql_exception: The command is out of sync; you cannot run this command now" when updating to php8.2.5 from an older PHP version

I have a mysqli wrapper for PHP5 that I wrote years ago but I get an error when trying to run it on PHP8.2.5. ...

From [MySQLdiscussion group] 2024-01-16 14:25:42 0  1  575

Limitations before a table can be sharded or partitioned

I'm new to database system design. After reading many articles, I am really confused what is the limit we shou...

From [MySQLdiscussion group] 2024-01-16 13:32:16 0  1  427

"Laravel Eloquent DB::Raw query does not support using WHERE statement and subquery at the same time"

When I paste the following query into my SQL tool it runs fine but returns zero rows when run through Laravel....

From [MySQLdiscussion group] 2024-01-16 13:01:17 0  1  506

Modifications to /etc/phpmyadmin/config.inc.php have not taken effect

I want to configure PhpMyAdmin to access only one database through one user. I have previously tried to restri...

From [MySQLdiscussion group] 2024-01-16 11:53:14 0  1  392

How to get data from another table referenced by a foreign key?

This is the table I want to get the data from, I'm using express to make a get request from the next app: mode...

From [MySQLdiscussion group] 2024-01-16 11:06:02 0  1  510

Subquery insert fails in MySQL 5.7

I'm writing SQL data migrations for an application that needs to support multiple possible databases, includin...

From [MySQLdiscussion group] 2024-01-10 18:12:10 0  1  551

Trigger query cannot be executed due to syntax error

There is a syntax error on line 5, can't find the problem I tried changing the variable names to no avail and ...

From [MySQLdiscussion group] 2024-01-10 18:02:49 0  1  447

How to validate fields and conditions when performing overrides

We have a central server and several regional servers such as d1, d2, d3, d4, d5. There are some tables to be ...

From [MySQLdiscussion group] 2024-01-10 18:06:26 0  1  418

How to add a column in select query with right join

I'm trying to find a way to add a country code to a database call record based on a phone number column. I hav...

From [MySQLdiscussion group] 2024-01-10 18:08:33 0  1  424