How to aggregate 2 procuderes into 1 in MySQL?

I have two programs that look almost identical. One person receives the location and price and performs the op...

From [MySQLdiscussion group] 2024-01-29 10:39:39 0  2  397

How can I install mysql without errors?

MySQL for this installation has been upgraded to 5.7.40, if you still need to run mysql_upgrade, use --forcedp...

From [MySQLdiscussion group] 2024-01-29 09:55:10 0  1  699

How to use UNIX_TIMESTAMP to get the 7 days before the last 7 days?

I'm using the following code to return results from a mySQL field called registered_at so that I can get users...

From [MySQLdiscussion group] 2024-01-29 08:51:42 0  1  413

Update the id of the second row based on the first id

My original data is as follows: sididamount1123024530345504788057870 The desired output is as follows: sididam...

From [MySQLdiscussion group] 2024-01-28 23:38:16 0  1  445

Node.js connect to MySQL Docker container ECONNREFUSED

Before marking this question as a duplicate, please note that I did read the other answer and it did not solve...

From [MySQLdiscussion group] 2024-01-21 15:41:18 0  1  644

Warning: mysqli_connect(): (HY000/2002): File or directory not found

I'm trying to install a vanilla forum on my Mac, for which I've just created a database and a user from the My...

From [MySQLdiscussion group] 2024-01-21 15:02:15 0  2  426

How to use JOIN to perform DELETE operations in MySQL

I have the following query: deletefromcustomers_cardswhereidnotin(selectmin(id)fromcustomers_cardsgroupbynumbe...

From [MySQLdiscussion group] 2024-01-17 00:36:18 0  2  596

Learn how to use inner joins and where clauses in MySQL

I have two separate tables, tuition and user. In the tuition table, I have two fields called user_id and admin...

From [MySQLdiscussion group] 2024-01-16 23:04:24 0  1  362

How to have MySQL inspect and validate static results from another column

This is the code I'm currently running: privatevoidbutton1_Click(objectsender,EventArgse){stringserver="2...

From [MySQLdiscussion group] 2024-01-16 21:09:31 0  2  400

How can I reformulate this query without using the AS keyword?

I'm completing a HackerRank challenge, but the documentation says I shouldn't use the AS keyword: I need to re...

From [MySQLdiscussion group] 2024-01-16 20:23:51 0  1  425

Legacy MySQL setup warning: mysql_connect(): file or directory does not exist

Dear developers, I have solved the original problem, but if anyone has a docker image that can run this, I wou...

From [MySQLdiscussion group] 2024-01-16 19:08:53 0  1  514

How to insert multiple values ​​into MySQL database using Python script

I have the following example values; lst=[{'title':'Guldför Odermattischweiziskdubbel','summary':'','link':'``...

From [MySQLdiscussion group] 2024-01-16 18:18:52 0  1  464

Title rewritten to: Image loading will be blocked when the image name contains hyphens, is too long, or relies on its position

I have some images placed in the C:\xampp\htdocs\catshop\assets\img folder under my website. If an image has a...

From [MySQLdiscussion group] 2024-01-16 18:25:49 0  1  401

Rewrite the maxscale filter using awk

The following rewrite rule works as expected: %%regex_grammar:Awkcase_sensitive:falseignore_whitespace:true%SE...

From [MySQLdiscussion group] 2024-01-16 18:26:12 0  1  399

Merge recursive CTE results into secondary SQL Select

I have a complex SQL query that successfully extracts the cost of component product records and calculates the...

From [MySQLdiscussion group] 2024-01-16 18:01:02 0  1  398