Use triggers to generate Unix timestamps on insert while allowing cloning of existing records and avoiding duplication

I'm making an event system. Let's say there is an event called "Go Dance" on September 12, 2022. Whe...

From [MySQLdiscussion group] 2024-01-10 17:51:06 0  1  373

Update column data in MySQL table

I'm just learning and don't understand how to update individual columns in a table, I'm using MySQL. The table...

From [MySQLdiscussion group] 2024-01-10 17:31:14 0  1  437

Query causing huge CPU utilization and high latency

The following query is causing huge CPU utilization and high latency in my database environment. I tried using...

From [MySQLdiscussion group] 2024-01-10 17:21:24 0  1  423

Set the value of the column matching ID in the same table to NULL

I'm working with housing data with multiple columns. During the cleaning process, I noticed that there are som...

From [MySQLdiscussion group] 2024-01-10 17:12:11 0  1  455

Are MySQL views more efficient than complex queries?

I'm having a problem with a SELECT statement using multiple inner joins. My code is as follows: SELECT`movies0...

From [MySQLdiscussion group] 2024-01-10 17:09:15 0  1  396

Room Java - Is it possible to run transactions in the interface?

I'm using room framework in my AndroidStudio project. I'm trying to create a transaction within an interface. ...

From [MySQLdiscussion group] 2024-01-10 17:15:07 0  1  432

java.sql.SQLNonTransientConnectionException: Unable to create a connection to the database server

I have an issue with error code "java.sql.SQLNonTransientConnectionException: Unable to create a connecti...

From [MySQLdiscussion group] 2024-01-10 16:45:25 0  1  394

Is utf8mb4_0900_ai_ci a suitable collation for general use in MySQL 8.0.30?

For storing and searching MySQL data in many different languages, such as indexing website titles for all doma...

From [MySQLdiscussion group] 2024-01-10 16:47:01 0  1  516

Weird character encoding for storing data, old script shows them fine, new script doesn't

I'm trying to rewrite an old website. It is in Persian and uses Persian/Arabic characters. CREATEDATABASE`db`D...

From [MySQLdiscussion group] 2024-01-10 16:51:57 0  2  368

Kubernetes MySQL deployment encounters /var/lib/mysql unavailable error

I'm trying to create mysql container at mount path /var/lib/mysql in kubernetes, but when I deploy, I get the ...

From [MySQLdiscussion group] 2024-01-08 15:43:19 0  1  492

Is there a way to improve the performance of MySQL imports that slow down over time?

I have a huge mysqldump file (~700GB) and I want to restore it on another server. For the first GB the import ...

From [MySQLdiscussion group] 2024-01-05 09:41:52 0  1  582

How to change SQL date format to YYYY-MM-DD?

I have a column called "start_date" with data type "DATE". On my database table it appears...

From [MySQLdiscussion group] 2024-01-04 16:42:59 0  1  579

Golang GORM implements data retrieval and join table query of many-to-many relationships

I'm using golang1.19 and ORM as GORM. I need to retrieve products using category ID. The product table and cat...

From [MySQLdiscussion group] 2024-01-04 13:57:53 0  1  473

What should I do if I can't see the MySQL tables when trying to export the schema?

Screenshot of MySQL export MySQL tables don't show up when trying to export my schema... I can see the tables ...

From [MySQLdiscussion group] 2024-01-02 22:06:30 0  1  414

How to prevent further execution of Express middleware

I want to get this function if(thereIsSomeError) //stop further execution. For example if some error occurs in...

From [MySQLdiscussion group] 2024-01-02 11:41:53 0  1  444