macOS Ventura causes failure to install 'mysql2' due to 'ld: library not found for -lzlib'

Unable to install mysql2 using bundleinstall. I ask this because some websites and blogs have shown how to sol...

From [MySQLdiscussion group] 2023-11-11 08:40:10 0  2  936

Retrieve MySql rows with the same column value

Let us consider the following table - IDScore19521003884100573 I am a complete SQL noob, but how to return a s...

From [MySQLdiscussion group] 2023-11-10 21:53:39 0  2  851

How to publish SQLite database data to an online MySQL database in Flutter?

How to sync offline SQLite to MySQL online database in Flutter? Any suggestions?

From [MySQLdiscussion group] 2023-11-10 12:36:40 0  2  859

Root user is denied access to MySQL

I recently installed MySQL on x86_64 Access denied for "localhost" (using password: no) With or with...

From [MySQLdiscussion group] 2023-11-09 11:00:45 0  1  758

What is the way to protect this function from SQL injection?

publicstaticboolTruncateTable(stringdbAlias,stringtableName){stringsqlStatement=string.Format("TRUNCATETA...

From [MySQLdiscussion group] 2023-11-07 22:03:43 0  2  757

sqlalchemy.exc.ArgumentError: list argument must contain only tuples or dictionaries

I've been trying to use sqlalchemy to dump data into a mysql database. When I try to do this, it gives the err...

From [MySQLdiscussion group] 2023-11-07 21:06:02 0  1  1048

Composite full-text index in MySQL

I want the system to allow searching user messages by specific users. Suppose I have the following table creat...

From [MySQLdiscussion group] 2023-11-07 18:44:49 0  2  625

Is full count query really that slow on a large MySQL InnoDB table?

We have a large table with millions of entries. Full counting is very slow, see code below. Is this common for...

From [MySQLdiscussion group] 2023-11-07 15:52:43 0  2  796

MySQL syntax for updating specific key/value pairs in JSON array

I have a table in a MySQL5.7.12 database with a JSON column. The data in the column has the following structur...

From [MySQLdiscussion group] 2023-11-06 14:50:43 0  1  838

The title is rewritten as: "Flutter mysql1 received out-of-order packets"

I'm having some issues setting up a connection to my VPS using flutter's mysql1 library. When I execute the qu...

From [MySQLdiscussion group] 2023-11-05 22:34:25 0  1  812

Sequelize CLI migration error: Cannot access property of undefined (specifically 'details')

I'm running npxSequelize-clidb:migrate to create a table in the database and the following message is returned...

From [MySQLdiscussion group] 2023-11-04 23:07:03 0  2  734

Rewrite the title as: Passing array of integers to MySQL stored procedure

I want to create a stored procedure which receives an array of integers and some other inputs like: CREATEPROC...

From [MySQLdiscussion group] 2023-11-03 10:46:21 0  2  654

PlanetScaleDb Prisma Configuration - Server does not allow insecure connections, clients must use SSL/TLS

I'm starting a brand new PlanetScale support project and setting it up using Prisma. I followed the instructio...

From [MySQLdiscussion group] 2023-11-02 08:58:00 0  1  829

The rewritten title is: Configuring PHPUnit database using PhpStorm Docker

I have set up PhpStorm using Docker: PHP, PHPUnit and I see the schema in PhpStorm/Database Viewer and I can u...

From [MySQLdiscussion group] 2023-11-01 20:53:17 0  1  760

MySQL: How to use CASE with ORDER BY clause

I have a stored procedure that has to return a table after filtering rows based on input. Two of the inputs ar...

From [MySQLdiscussion group] 2023-11-01 17:44:15 0  1  653