Solving query problem: How to get all the results from the Customers table and replace the null values ​​in the Status and Fax columns with empty strings?

I'm very confused about this question. The problem is that I know I can use the COALESCE function, but how? Be...

From [MySQLdiscussion group] 2024-04-01 15:06:14 0  1  574

How to bypass check constraints in SQL

架构createtablecourse(course_idvarchar(8),titlevarchar(50),dept_namevarchar(20),creditsnumeric(2,0)check(credits...

From [MySQLdiscussion group] 2024-04-01 15:19:51 0  1  575

How do I link to a custom library when building MySQL server from source?

I installed MySQL server using the standard source distribution (mysql-server-8.0) according to: https://dev.m...

From [MySQLdiscussion group] 2024-04-01 14:30:27 0  1  499

Find year range for Mysql REGEXP

I want to separate the content in a table on my movie website based on year intervals, but no matter how hard ...

From [MySQLdiscussion group] 2024-04-01 14:26:29 0  1  602

PHP query update data

This is the error I get: Updated question SETsituacao='Concluido'WHEREid=?SQLSTATE[42000]: Syntax error or acc...

From [MySQLdiscussion group] 2024-04-01 13:41:23 0  1  569

Make a button in html delete a row in MySql

I'm currently working on a project where I'm using nodejs to create a user, add the user to MySql in a table c...

From [MySQLdiscussion group] 2024-04-01 13:24:27 0  1  501

MySQL query statement: display data for the last 4 weeks

How to write a query in MySQL to retrieve data for the past 4 weeks starting from today. I googled the query b...

From [MySQLdiscussion group] 2024-04-01 13:12:56 0  1  436

Match records between EventA and the previous EventB before the subsequent EventA in a specific order

I have the following data (fiddle), iddatec event 12022-09-1912:16:38EVENTA22022-09-1912:16:38A32022-09-1912:2...

From [MySQLdiscussion group] 2024-04-01 13:05:30 0  1  392

Want to show checkbox for each row

Currently, in our office website, there is a user input text box, and when inserted, the results from the data...

From [MySQLdiscussion group] 2024-04-01 12:34:11 0  2  424

PHP OOP - Return result of $obj->get() and $obj->get()->count() without calling another method

It's hard to explain exactly what I want, but I have to try... LaravelEloquent inspired me to write a simple p...

From [MySQLdiscussion group] 2024-04-01 12:28:10 0  1  574

Implementing an optional two-way user relationship: a step-by-step guide

I have a user model and there is some relationship between these users. Example: John is the father of Jack an...

From [MySQLdiscussion group] 2024-04-01 12:05:59 0  1  526

Will migrate BLOB fields in MySQL table to BLOB fields in SQLite table

I have a table in database mysql containing one column of type BLOB. I want to export to sqlite database with ...

From [MySQLdiscussion group] 2024-04-01 11:14:54 0  1  613

How to add one more column to the same table while retaining the group by clause

Column list in Table 1: Plan_ID, Claim_id, Patient_id, B_OR_G Column list in Table 2: Ojid, Shapland selectdis...

From [MySQLdiscussion group] 2024-04-01 10:43:59 0  1  464

Python: Pymysql hangs silently with no response?

The first application using Python. My application hangs on pymysql calls, is this library stable? Just trying...

From [MySQLdiscussion group] 2024-04-01 10:55:37 0  1  569

There is a syntax error in the SQL query near line 1 "OVER (ORDER BY r.Id)) AS Grown FROM results AS r ORDER BY r.Id LIMIT 0.25"

I have a SQL command that uses lag to list data from a table and calculate it against the previous value to ca...

From [MySQLdiscussion group] 2024-04-01 10:36:24 0  1  488