How to do phantom data entry in SQL?

Question

MySQL

There is a need to create a request to write data, but at the same time it is not permissible to execute until a flag arrives, in order to then create all the records in different tables at once. Let's just say a person sends a request to create a user and an error occurred with a duplicate key in one of the tables, 1 and 2 are valid, but 3 is not valid, it displays an error that 3 is not valid, but 1 and 2 should be rolled back. Has anyone done something similar?

Answer 1

Place the request in a transaction.