MySQL Basic beginner Learn "10" multiple table Delete

DELETE tbl_name [. *] [, tbl_name[.*]] ...

From Table_references

[WHERE Where_condition]

Now you want to delete the duplicate records and keep the records with the smaller ID numbers.

A table simulates multiple table deletions to achieve:

(1) Finding duplicate records

(2) Refer to this table to delete the data from the table above

"Involves subqueries, joins, multiple table updates, multiple table deletions, implements its own connection when multiple table operations are made, and deletes duplicate records through its own connection"

MySQL Basic beginner Learn "10" multiple table Delete