Undefined constant 'text' in /home/jokebo/public_html/index.php:23

I have a PHP project that connects to a SQL database. The problem is that I cannot access the value of text in...

From [MySQLdiscussion group] 2023-09-16 16:33:51 0  1  730

How to execute second query when first query has no results - MYSQL

How to get results in MYSQL: If the first selection has more than 0 rows, return the results, otherwise return...

From [MySQLdiscussion group] 2023-09-16 16:12:30 0  1  1046

How to update the value of "last_dt" column when using "UPDATE" or "INSERT IGNORE INTO ~ ON DUPLICATE KEY UPDATE ~" statements

The last_dt column is the date the data was last changed. It is managed differently than inserted dates. Inser...

From [MySQLdiscussion group] 2023-09-16 13:54:41 0  1  843

Create new unique value in column

I have a (MYSQL) table in the following format; assuming the name of the table is mytable:id namegroup123name1...

From [MySQLdiscussion group] 2023-09-16 13:14:40 0  1  844

MAX(CONVERT(column, TIME(3))) returns different values ​​from mysql client than JPA native query

The value returned by MAX(CONVERT(column,TIME(3))) from the mysql client is different from the value returned ...

From [MySQLdiscussion group] 2023-09-16 12:15:25 0  1  990

Why is there only column name but no where equal to value in MySQL? It is not a syntax error

Why is such a query not a syntax error? I have a SQLServer background and I'm really surprised. SELECT * FROM ...

From [MySQLdiscussion group] 2023-09-16 10:37:20 0  1  668

Rewrite the title to: Upload to MySQL using a CSV file with a single column containing multiple lines of text, double quotes, and commas

I have a problem uploading data to mysql database. The data looks like this: review_id, user, text A typical r...

From [MySQLdiscussion group] 2023-09-16 10:05:22 0  1  479

Using test-driven development, in NestJS API, controllers and services share the same tests

I'm developing a NestJS based API using Prisma and MySQL. Since I'm new to test-driven development (TDD), I wa...

From [MySQLdiscussion group] 2023-09-16 08:44:31 0  1  520

Get latest data from SQL based on date or ID

How can I get the latest data from this query, actually the table is crowded and we need the latest data from ...

From [MySQLdiscussion group] 2023-09-16 00:02:05 0  1  657

Store HTML DOM results into MySQL database

I'm trying to store scraped data into my database. It just outputs the results, so the crawling is normal. But...

From [MySQLdiscussion group] 2023-09-15 23:41:06 0  1  564

How can I create a SQL query that uses Col A as the primary sort key, but if Col A is empty, uses Col B as the primary sort key?

Using MariaDB, I have a view that provides information including the date of the event and whether the invitat...

From [MySQLdiscussion group] 2023-09-15 22:59:52 0  1  665

Am I able to use the mysql built-in function get_lock?

There is a batch job out there. And there are multiple servers that can handle the job. I only want the job to...

From [MySQLdiscussion group] 2023-09-15 21:20:11 0  1  690

Can't query selected data when my date is full

I have a database structure like this: and I want to check the room types available on a specific date, so I r...

From [MySQLdiscussion group] 2023-09-15 19:38:13 0  1  529

How can I add a relationship to these two tables when there is an id and a prefix in the primary key?

I don't know how to link these two tables. Can anyone help? I want to add a relationship in these two tables b...

From [MySQLdiscussion group] 2023-09-15 15:03:48 0  1  538

Driver not found on PDODb on Apache2 PHP 7.4

I use Ubuntu22.04 and php7.4. I try to use apache2 to provide a virtual host for my website. The login page ca...

From [MySQLdiscussion group] 2023-09-15 14:55:04 0  1  694