How to use LIMIT and placeholders in MySQL (Node.JS)

When executing queries using placeholders in Node.js and MySQL, the LIMIT placeholder does not seem to work pr...

From [MySQLdiscussion group] 2023-07-24 21:17:01 0  1  649

bloginfo('stylesheet_directory') does not return the path.

I created a WordPress theme years ago and then forgot about it. But recently I was asked to make some changes ...

From [MySQLdiscussion group] 2023-07-24 19:17:03 0  1  540

Error: MySQL - operand should contain 1 column.

This query works when I type it directly into MySQL, but not in C#. doubledeltaTime=(DateTime.Now-collectTime)...

From [MySQLdiscussion group] 2023-07-24 18:17:13 0  1  461

Returning the value of the previous row based on a union CTE sorted by date is slow.

According to the following sports competition table: id_p1_idp2_idmatch_datep1_statp2_stat 8526661201/01/1...

From [MySQLdiscussion group] 2023-07-24 17:47:03 0  1  383

Can anyone find the error in this MySQL code? (Beginner)

I'm thinking about a MySQL job benchmark and trying to create a data called students. However, I removed the e...

From [MySQLdiscussion group] 2023-07-24 17:17:03 0  1  419

How to deal with mysqli problems? For example, an error occurs in mysqli_fetch_array(): Parameter #1 must be of type mysqli_result.

In my local/development environment, the MySQLi query runs fine. However, when I upload it to my web hosting e...

From [MySQLdiscussion group] 2023-07-24 16:47:03 0  1  470

In MySQL, what is the difference between storing data in multiple columns vs storing data in JSON columns

Let's say I have a table called T1. Initially, it has ID, Identifier, C1, C2 as columns. Over time I will add ...

From [MySQLdiscussion group] 2023-07-24 16:17:05 0  1  510

Count the number of Laravel and Mysql related models through intermediate tables using additional conditions.

I have a MySQL query built using Laravel Eloquent's eager loading and withCount functions, but I have some per...

From [MySQLdiscussion group] 2023-07-24 15:47:02 0  1  606

Main query and subquery - subquery not returning desired results

I have the following SQL query for a comment system. Select `main`.`comment_id`, `main`.`comment`, `main`.`tim...

From [MySQLdiscussion group] 2023-07-24 15:42:03 0  1  403

MYSQL get maximum value from a specific date

I have years of temperature measurement data. Find the highest temperature measurement including dates recorde...

From [MySQLdiscussion group] 2023-07-23 17:50:20 0  1  593

AJAX POST and the plus sign (+) - how to encode it?

I'm posting the contents of a field to a PHP script via AJAX and using JavaScripttoscape(field_contents). The ...

From [MySQLdiscussion group] 2023-07-21 09:47:06 0  2  674

Create table using SELECT syntax in MySQL

I'm wondering how MySQL interprets CREATETABLEEsyntax:IfIwrite:CREATETABLEtbl1(`v1`int, `v2`intCONSTRAINTidxPR...

From [MySQLdiscussion group] 2023-07-20 22:47:01 0  1  594

How to integrate Angular application with MySQL database?

I'm writing my first Angular application, but I can't find how to integrate it with my SQL database. This is a...

From [MySQLdiscussion group] 2023-07-20 21:47:01 0  1  540

How to fix bug: #1977 - Unable to convert 'utf8' character 0xD8AD to 'latin1'.

I'm working in phpMyAdmin and I have Arabic character values ​​in my name column like کلبالرقيÙ'ةعل...

From [MySQLdiscussion group] 2023-07-18 19:47:03 0  1  596

mysql: key reference and table reference do not match

Error message: SQLSTATE[42000]: Syntax error or access violation: 1239 Incorrect foreign key definition for 'f...

From [MySQLdiscussion group] 2023-07-18 15:17:02 1  1  657