MySQL deduplication, why can only a few hundred or dozens of duplicate data be removed each time, when there are obviously hundreds of thousands of duplicate data?

Requirement: Delete the items with the same primaryid and drugname in DRUG, and keep the smallest row of drug_...

From [MySQLdiscussion group] 2022-09-05 14:49:26 0  0  891

Online registration for courses and exam functions

Publish courses in the background -> Users can pay to register for multiple courses to study -> After us...

From [MySQLdiscussion group] 2022-09-02 09:53:21 0  1  944

How to deal with the following one?

Error reported around line 307 of /core/library/think/db/Connection.php. The database account/password is inco...

From [MySQLdiscussion group] 2022-08-12 04:39:53 0  1  1273

SQL slow query causes CPU memory to reach 100%, what should I do?

It is said that there are a large number of slow query records in the database, and the execution time is too ...

From [MySQLdiscussion group] 2022-08-11 11:19:09 0  3  1249

Using the from method to find the latest products under each column, why are the results incorrect?

Use the from method to find the latest products under each column, why are the results incorrect? select goods...

From [MySQLdiscussion group] 2022-08-09 13:50:58 0  2  784

Can mysql5.5 use match against usage?

Can mysql5.5 use match against usage? Why no data is returned when I test the data set: user_id user_tags1 Swi...

From [MySQLdiscussion group] 2022-05-19 18:21:55 0  0  1351

day4 1.5 lost video

day4 1.5 lost video

From [MySQLdiscussion group] 2022-05-07 15:41:57 0  3  1233

Please take a look at mysql exclusive lock problem

Please help. Doesn’t it mean that when the exclusive lock does not commit the transaction, this data cannot be...

From [MySQLdiscussion group] 2022-03-01 11:59:27 0  0  1221

phpstudy 2018 How to install mysql extension (windows)

I downloaded phpstudy 2018 and want to use php7.2 for development, but mysql is not supported. Has anyone enco...

From [MySQLdiscussion group] 2022-02-20 23:16:00 0  1  1321

New installation of mysql5.5 in Xiaopi Panel prompts that there is no permission

From [MySQLdiscussion group] 2022-01-18 21:35:40 0  2  1322

MySQL cannot connect from outside

MySQL cannot be connected from the outside, what should I do? Php has installed tools such as MySQL pod, but I...

From [MySQLdiscussion group] 2022-01-07 14:21:59 0  2  1136

Virtual centos error when connecting to mysql

内容Can't connect to local MySQL server through socket '/tmp/mysql.sock'

From [MySQLdiscussion group] 2021-12-10 12:57:42 0  0  1152

2-8 The video deleted from the database was placed in the wrong place

2-8 The video deleted from the database was placed in the wrong place

From [MySQLdiscussion group] 2021-11-25 14:17:15 0  6  1163

Problems arising from second installation of MySQL service

After re-operating with Super Pipeline Manager, it prompts that the service cannot be started. After configuri...

From [MySQLdiscussion group] 2021-11-12 09:58:11 0  3  1558

Why use version 5.7 instead of 8.0?

Why not use the latest version

From [MySQLdiscussion group] 2021-11-09 23:18:06 0  4  1181