Unable to use LIMIT delete in mysql join query between multiple tables

Here is my SQL query: DELETEgurFROMgroup_mastergmJOINgroup_usersguONgu.group_id=gm.idJOINgroup_user_rolesgurON...

From [MySQLdiscussion group] 2024-04-01 10:21:30 0  1  511

How to use DateDIFF function in mysql table

I have a dataset in my library management system and I am using the query below to get only specific fields. s...

From [MySQLdiscussion group] 2024-04-01 10:12:54 0  2  474

Find the sum of columns based on the values ​​of column (X) and get all values ​​of another column where X exists

I have the following table: id code amount quantity 112536223063510014125100512016410136711020 I want to find ...

From [MySQLdiscussion group] 2024-04-01 09:28:58 0  2  439

Unable to start mysql server on docker container

I have a NestJS application that I want to dockerize. I'm new to docker and I have to do this. In my NestJS ap...

From [MySQLdiscussion group] 2024-04-01 00:00:35 0  1  2665

MYSQL query to copy all data in a column from one database to another

I accidentally used the "Generate Description" feature on the Opencart SEO tool and it overwrote all...

From [MySQLdiscussion group] 2024-04-01 00:00:37 0  1  564

Unable to establish external connection to MySQL/MariaDB database

I'm trying to connect a MariaDB client (DBeaver) to my database from my home computer. The IP address/host, po...

From [MySQLdiscussion group] 2024-03-31 23:39:43 0  1  492

Querying for distinct values ​​where id is in a list of values ​​- gives me a wrong result

$('#btnmails').on('click',function(){letids=$.map($('.atitle'),(e)=>$(e).attr('data-id'));ids=JSON.stringif...

From [MySQLdiscussion group] 2024-03-31 23:37:37 0  1  458

Solve the problem of operation error when pythonanywhere connects to MySQL database

I have finished my django project and I want to test it on PythonAnywhere, everything was fine until the mysql...

From [MySQLdiscussion group] 2024-03-31 22:43:19 0  1  576

How to prevent duplicate entry in multiple columns?

CREATETABLE`FOLLOWERS`(`FOLLOWER_ID`char(255)COLLATEutf8_unicode_ciNOTNULL,`FOLLOWING_ID`char(255)COLLATEutf8_...

From [MySQLdiscussion group] 2024-03-31 22:54:17 0  1  400

Save post metadata for SQL query results when using "woocommerce_thankyou" hook

I'm trying to query a database and pass the results to the update_post_meta function. But not sure if I'm buil...

From [MySQLdiscussion group] 2024-03-31 21:34:04 0  1  522

Copy activities from a MySQL view with parameters to Azure SQL Database using Azure Data Factory

I'm trying to use Azure Data Factory to copy a MySQL view with parameters to an AzureSQL database. Here is the...

From [MySQLdiscussion group] 2024-03-31 20:56:52 0  1  411

How to get relational table data name instead of id

I have two tables hero id name universe_id12 tag 199 glume 1 universe id name 1 andromeda 2 aurora how to retu...

From [MySQLdiscussion group] 2024-03-31 20:48:12 0  2  428

SQL syntax error 1064: There is an incorrect "VISIBLE" part in your SQL syntax

I'm actually just trying and experimenting with MySQL Workbench and Azure Database for the first time. So, I m...

From [MySQLdiscussion group] 2024-03-31 19:52:50 0  1  460

Docker Image: Integration of PHP 8.0, Apache and phpMyAdmin

I'm creating an image for a php8 project running on apache and using phpMyAdmin, my Dockerfile is as follows: ...

From [MySQLdiscussion group] 2024-03-31 18:19:17 0  1  498

After copying website to local, WordPress homepage redirects to duplicate copy

Background: I have multiple websites running on rpi4 using nginx and wordpress. I want to copy one of the site...

From [MySQLdiscussion group] 2024-03-31 15:26:18 0  2  462