How to start MySQL transaction that will be committed by mysql_commit()
It looks like MySQL C API indeed doesn't have a dedicated function that is equivalent of the START TRANSACTION
SQL statement.
The MySQL C API has mysql_commit()
function that does the same as COMMIT
SQL statement.
The MySQL C API has mysql_rollback()
function that does the same as ROLLBACK
SQL statement.
But, there is no function for starting the transaction in this API.