MySQL method to extract all keys in nested JSON string

In addition to this answer, is it possible to extract the nested keys in a simple way? Example: {"a"...

From [MySQLdiscussion group] 2023-08-28 14:17:16 0  1  503

The rewritten title is: Remove elements one by one from an array using Laravel Ajax

I'm trying to remove each element from an array that is displayed as an image via Append. Blade: <h4>Men...

From [MySQLdiscussion group] 2023-08-28 14:20:24 0  1  562

How to use Python connector to check if a table/database in MySQL already exists?

So, I want to create a program that will take input from the user about everything, i.e. database name, table ...

From [MySQLdiscussion group] 2023-08-28 13:31:54 0  1  534

How to solve the problem of not being able to update the "Date Column": How to correctly upload a CSV file when updating a MySQL database table

The main problem in my code is that I cannot update the "date" from the csv file into the mysql data...

From [MySQLdiscussion group] 2023-08-28 13:46:51 0  1  558

Generate dynamic table of all months between two dates

I have a table that looks like this: Names INT_VALUE starts END with a 1002013-11-16 2014-11-16 The goal is to...

From [MySQLdiscussion group] 2023-08-28 12:44:46 0  2  569

How to resolve error on Node.js backend: Connection ECONNREFUSED: :1:3306?

I rebuilt my hosting server but after setting up mysql I get the error from the Node.js backend: Error:connect...

From [MySQLdiscussion group] 2023-08-28 12:36:30 0  1  670

Error 1115 (42000): Unknown character set: 'utf8mb4'

I have a MySQL dump and I tried to restore it using: mysql -u"username"-p"password"--host=...

From [MySQLdiscussion group] 2023-08-28 11:56:56 0  2  470

How to concatenate multiple MySQL rows into one field?

Using MySQL I can do the following: SELECThobbiesFROMpeoples_hobbiesWHEREperson_id=5; My output: shoppingfishi...

From [MySQLdiscussion group] 2023-08-28 11:10:23 0  2  418

Solving "communication link failure" issues using JDBC and MySQL

I'm trying to connect to my local MySQL server but I keep getting an error message. Here is the code. publiccl...

From [MySQLdiscussion group] 2023-08-28 10:53:42 0  1  481

In Mysql, batch add multiple columns to table based on another column

I have a table with three columns. For each id, we have up to 400 index values. I want to add columns based on...

From [MySQLdiscussion group] 2023-08-28 11:03:44 0  1  514

Docker Compose - Connection to Phpmyadmin and MySQL not working

I need an easy way to create an environment containing PHP, NGINX, MySQL and phpmyadmin using Docker-compose. ...

From [MySQLdiscussion group] 2023-08-28 09:00:04 0  1  640

How to clear database cache in mysql 8 innodb

I've tried running the same query multiple times on the same mysql8 database and table. I need to experiment t...

From [MySQLdiscussion group] 2023-08-27 23:46:28 0  2  651

The title is rewritten as: Use Sequelize to count the number of rows in related tables

Using sequelize and mySQL, I have two tables: User and Post. The relationship between the two tables is M: Ndb...

From [MySQLdiscussion group] 2023-08-27 22:35:45 0  1  399

Example of relationship involving multiple entities

I haven't found any examples of MYSQL many-to-many relationships neither here nor in Google. What I'm looking ...

From [MySQLdiscussion group] 2023-08-27 21:44:53 0  2  496

Retrieving and displaying images from a database in a JSP page: a step-by-step guide

How to retrieve and display images from database in JSP page?

From [MySQLdiscussion group] 2023-08-27 21:30:22 0  1  745