SQL multivolume atomatics question

Question

I am trying to create a program that updates two different tables using sql commands. The only thing that bothers me is that if the program updates one of the tables and then loses the connection or something else and does NOT update the other table, a problem may occur. Is there a way I could

and. Update them at the same time.

or

C. Return the first update if the second fails.

Answer 1

Yes uses transaction SQL. Here is a tutorial: JDBC transactions

Answer 2

. :

• MySQL
• Oracle
• SQL Server
• PostgreSQL

( - ​​ , ), ... , ( SQL-), , - .

Answer 3

SQL- , .. , . :

START TRANSACTION;
 *do stuff*
COMMIT;

, , . , MySQL.