mysql 用C语言事务怎么写呵？

if(mysql_query(m_pConn,"begin"))
{
printf("start transaction-------\n");
}
if(mysql_query(m_pConn,"insert into T_index_1_2_2(time_from,time_to,data_offset,data_length) values(1,1,14,1)"))
{
printf("inser to err\n");
}

if(mysql_query(m_pConn,"rollback"))
{
printf("start rollback-------\n");
}上面的语句好像不行，插入表照样成功。