docker-compose health check passes, but still unhealthy

The condition compose specification was removed in versions 3.0 to 3.8, but now it's back! With v3.9 of the co...

From [MySQLdiscussion group] 2024-02-26 10:58:41 0  2  384

Switch a column when joining two SQL tables

The scenario is if I have a student table and they have 4 classes and they only know the room number. There ar...

From [MySQLdiscussion group] 2024-02-26 09:29:39 0  1  411

Export table from PHPmyAdmin

I'm currently facing an issue exporting tables or databases from phpmyadmin. This is the result: This is my ve...

From [MySQLdiscussion group] 2024-02-26 08:58:50 0  1  467

How to get the first wire_open and wire_close group in the data

This is the data I want to output, it matches the blue line and the photo of the desired output I have attache...

From [MySQLdiscussion group] 2024-02-26 08:47:46 0  1  368

What's wrong with this method of dynamically updating multiple rows?

exports.createTaskDataForNewDay=asyncfunction(values){try{console.log("values",JSON.stringify(values...

From [MySQLdiscussion group] 2024-02-26 00:32:34 0  2  344

Sql multiple conditions in two tables return wrong data

I have two MySql tables Courses(CNO:CHAR(10),CName:VARCHAR(50),DeptId:CHAR(3)) with the following schema:Eachc...

From [MySQLdiscussion group] 2024-02-25 23:56:56 0  1  403

Unable to delete or update parent row

I'm a new user. I would like to ask about an error I encountered in my homework project. I create room_type_id...

From [MySQLdiscussion group] 2024-02-26 00:10:28 0  1  455

C#: timestamp truncated?

Running the command text in MySQL workbench returns the following code at 2023-04-0911:37:05.508, which is tru...

From [MySQLdiscussion group] 2024-02-25 23:33:08 0  1  350

Partition using multiple fields and get the same grouping number in each partition

I have a dataset that looks like this: Car Type Date Car Honda May 28, 2022 Car 1 Honda May 28, 2022 Car 1 Hon...

From [MySQLdiscussion group] 2024-02-25 22:59:56 0  1  314

How to update mysql column using array

I am using mysql, I have the table "wp_notification", here is the current structure of the table idU...

From [MySQLdiscussion group] 2024-02-25 22:36:28 0  1  320

Wrong use of MySQL SELECT INNER JOIN

I'm trying to retrieve the set of "roles" given users.id using a query using INNERJOIN combined with...

From [MySQLdiscussion group] 2024-02-25 22:06:14 0  2  431

Flags with different granularity in SQL

I'd like to say that I'm still learning how to use SQL, so the questions I'm asking may be easy for some of yo...

From [MySQLdiscussion group] 2024-02-25 21:48:26 0  1  312

Find records containing characters other than letters, spaces, and periods among the 7 million records stored in MYSQL VER 8

I have inserted special characters in MYSQLDB as shown in the example below, mainly in the first name, last na...

From [MySQLdiscussion group] 2024-02-25 21:01:35 0  1  455

SQL query to get the time of each status

Given a table as shown below |date|From|To||01/01/21|Open|Inprogress||01/03/21|Inprogress|Inreview||01/10/21|I...

From [MySQLdiscussion group] 2024-02-25 21:01:57 0  1  400

How to convert SHOW INDEX to ALTER TABLE to add index in MySQL

I executed SHOWINDEX on the table and this is the output I got: Table:logfileNon_unique:0Key_name:PRIMARYSeq_i...

From [MySQLdiscussion group] 2024-02-25 20:46:00 0  2  455