Is storing delimited lists in database columns really that bad?

Imagine a web form with a set of checkboxes (any or all of them can be selected). I chose to save them in a co...

From [MySQLdiscussion group] 2023-08-27 19:52:49 0  2  486

Reorganized title: Calculating the total value of other columns using MySQL's Group By and Sum

I have two columns like this: Word Amount Dog 1 Dog 5 Elephant 2 I want to sum the amounts and get the result ...

From [MySQLdiscussion group] 2023-08-27 19:13:59 0  2  546

Rewrite the title as: Convert JSON array to rows in MySQL

Update: This is now possible in MySQL8 via the JSON_TABLE function: https://dev.mysql.com/doc/refman/8.0/en/js...

From [MySQLdiscussion group] 2023-08-27 18:03:29 0  2  712

Warning: mysqli_connect(): (HY000/2002): No such file or directory

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] 2023-08-27 17:47:27 0  2  542

Dynamic Column MySQL PivotTable Query

I use the following table to store product data: mysql>SELECT*FROMproduct;+---------------+---------------+...

From [MySQLdiscussion group] 2023-08-27 17:24:10 0  2  449

Understand the functionality of the Statement.setFetchSize(nSize) method in the SQL Server JDBC driver

I have a very large table with millions of records every day, and at the end of each day I pull all the record...

From [MySQLdiscussion group] 2023-08-27 17:05:57 0  1  573

How to display outstanding transactions in MySQL

I made some queries without commit. Then the application is stopped. How can I display these open transactions...

From [MySQLdiscussion group] 2023-08-27 16:03:45 0  2  476

UTF-8 encoding is used throughout

I'm setting up a new server and want full UTF-8 support in my web application. I've tried this in the past on ...

From [MySQLdiscussion group] 2023-08-27 15:50:39 0  2  500

The target table for updates cannot be specified in the FROM clause

I have a simple mysql table: CREATETABLEIFNOTEXISTS`pers`(`persID`int(11)NOTNULLAUTO_INCREMENT,`name`varchar(3...

From [MySQLdiscussion group] 2023-08-27 14:46:57 0  2  381

How to catch PHP fatal errors (`E_ERROR`)?

I can use set_error_handler() to catch most PHP errors, but it doesn't work with fatal (E_ERROR) errors, such ...

From [MySQLdiscussion group] 2023-08-27 14:42:20 0  1  577

Delete from two tables in one query

I have two tables in MySQL #messagestable:messageidmessagetitle..#usersmessagestableusersmessageidmessageiduse...

From [MySQLdiscussion group] 2023-08-27 13:45:48 0  2  505

Updates to multiple databases - mysql

I'm new to mysql. I have a list of 10 databases containing the same table structure. The same table needs to b...

From [MySQLdiscussion group] 2023-08-27 11:15:21 0  1  502

When calling Spring Boot REST API multiple times using the same JDBC connection

I have a REST web service written in Java/SpringBoot, running on Tomcat9. I need to create a MySQL temporary t...

From [MySQLdiscussion group] 2023-08-27 09:40:00 0  1  589

Laravel Sail Docker MySQL connection issue

I'm trying to access the database through a Laravel application deployed in a Docker container, but I'm gettin...

From [MySQLdiscussion group] 2023-08-27 00:43:45 0  1  577

Best Way: Retrieve, Encrypt, and Update Millions of Records in MySQL Using Java 8

We have a requirement where we need to read approximately 10 million records from a MySQL database, encrypt th...

From [MySQLdiscussion group] 2023-08-27 00:17:18 0  1  638