Re: Inserting data to two tables

[Eran Yasso]

I read the documentation. The START TRANSACTION ends only after COMMIT or ROLLBACK are sent.
If I am not mistaken, in case the connection between MySQL client and MySQL server closed is I will still need to call COMMIT\ROLLBACK, or when connection is closed the START TRANSACTION ends?

I am afraid that in some case, the connection between the client to the server will be closed before COMMIT or ROLLBACK are sent and MySQL server will be in TRANSACTION state.

Thanks,