Does MYSQL roll back automatically when foreign key constraints or other errors occur?

Does MYSQL roll back automatically when foreign key constraints or other errors occur? Does MYSQL roll back automatically when foreign key constraints or other errors occur?
Do you need to manually determine the foreign key and then manually roll back?

Reply to discussion (solution)

What is automatic rollback? Where can I roll back?
Since an error occurs, the executing command does not do anything, so there is no rollback.

This is also true when foreign key constraints exist. MySQL verifies that a successful sub-table of the primary table fails or a successful self-table master table fails, the operation will be completed only when all operations are successful.

Transaction rollback is not a MySQL function, but a user requirement. Mysql only provides a container to help you implement