Will pass variables in SELECT statement in MySQL 8

I'm trying a simple select statement with variables. If I change the statement like concat_ws('%',@S,'%'); it ...

From [MySQLdiscussion group] 2024-02-17 20:03:04 0  1  526

How to insert two different arrays into a table with SQL INSERT INTO statement?

It's been so long since I messed with SQL that I had to start using it all over again when I built my own vide...

From [MySQLdiscussion group] 2024-02-17 18:59:52 0  1  373

Update numeric data in two rows using Laravel MySQL

I have a details table in my database that contains the number of rows. See below. Divided into two rows, ther...

From [MySQLdiscussion group] 2024-02-17 18:43:50 0  1  317

Embedding query operations in MySQL IF statements

Is there a way to run insert query in IF statement, I know the syntax of if statement is IF (condition, statem...

From [MySQLdiscussion group] 2024-02-17 16:44:15 0  1  479

MySQL: Combining all results in a loop (possibly using UNION?)

EDIT: Already solved and answered: But if you have a similar question, feel free to read and see how the proce...

From [MySQLdiscussion group] 2024-02-17 15:31:33 0  1  377

Query index with WHERE clause and ORDER BY not used

I have created a table as below CREATETABLEIFNOTEXISTS`table`(idVARCHAR(100)NOTNULL,seq_idBIGINTUNSIGNEDNOTNUL...

From [MySQLdiscussion group] 2024-02-17 15:09:50 0  1  423

MySQL to get customer ID and 20th transaction date - SQL query

I can't make a query to get a list of customer IDs and the date of their 20th purchase. I got a table called t...

From [MySQLdiscussion group] 2024-02-17 13:35:57 0  2  449

Create charts with Google Charts using HTML <form>

Recently I've been trying to insert visual analytics into a project I've been working on, and I'd like to be a...

From [MySQLdiscussion group] 2024-02-17 13:27:20 0  1  419

The signature image path cannot be saved to the database

I use https://laratutorials.com/signature-pad-php-mysql-jquery/ to create the signature pad. The problem is th...

From [MySQLdiscussion group] 2024-02-17 12:52:43 0  1  347

Why does mysql save json in reverse order? how to fix it

This is the code to insert json in my sql functioninsert_ema($json){$a=newSql();$b=$a->connection;$sql=&quo...

From [MySQLdiscussion group] 2024-02-17 13:04:55 0  1  375

Add multiple roles to protected routes (Node + Express + JWT)

I'm trying to secure some routes using user roles (some routes accept multiple roles). When I list the accepte...

From [MySQLdiscussion group] 2024-02-17 12:46:28 0  1  291

django.db.utils.IntegrityError: (1452, 'Cannot add or update child row: foreign key constraint failed

fromdjango.dbimportmodelsfromdjango.contrib.auth.modelsimportUser My model used to look like this. classLogin(...

From [MySQLdiscussion group] 2024-02-17 11:54:47 0  1  473

MySQL: Cannot update table 'order' in stored function/trigger because it is already used by a statement that calls this stored function/trigger

I have a table called orders in a MySQL database. The payment_date attribute is Null until we receive the fund...

From [MySQLdiscussion group] 2024-02-04 11:46:04 0  1  572

Looking for help with MySQL query - Calculate timestamp count within grouped range

One would think this would be easy, but it was a grind all night long. I have a sensor alert log and would lik...

From [MySQLdiscussion group] 2024-02-04 11:20:54 0  1  647

Django. After migrating mysql table, manage.py does not work

I installed mysql as database in django project. I did makemigration and migrated it to django. Afterwards I w...

From [MySQLdiscussion group] 2024-02-04 09:42:38 0  1  506