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  393

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  419

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  481

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  383

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  353

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  410

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  467

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  359

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  330

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  337

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  442

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  320

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  460

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  407

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  458