mysql multistatement query problem(if one query fail how we rollback)

[amit pathak]

Hello all,
I am using Mysql c api for database interaction, I want to know that if one query of Mysql multi statement fail then how we roll back all query which successfully executed..
ex-
mysql_query(conn,"select * from account_db; select count(*) from account_dbb;select * from account_db")
if there are a scenario where queries are dependent to each other and here if one query fail then related other query should be rollback for making database consistency,[ mysql multi statement execute query one by one so how we will check all query will be run , if all can be run, then only process continue]
Here in this example , second query is wrong, i want to do, if anyone query fail, no changes should be occour in database, is this possible?