This shows you the differences between two versions of the page.
c:mysql:mysql.h:mysql_autocommit [2013/02/26 22:52] 158.181.88.241 |
c:mysql:mysql.h:mysql_autocommit [2024/02/16 01:12] (current) |
||
---|---|---|---|
Line 42: | Line 42: | ||
} | } | ||
- | mysql_select_db(my,"test"); | + | mysql_select_db(my,"test"); // select DB |
- | mysql_autocommit(my, 1); | + | mysql_autocommit(my, 1); // set autocommit to ON |
mysql_query(my, "SELECT @@autocommit"); | mysql_query(my, "SELECT @@autocommit"); | ||
mysql_res = mysql_store_result(my); | mysql_res = mysql_store_result(my); | ||
- | row = mysql_fetch_row (mysql_res); | + | row = mysql_fetch_row (mysql_res); // fetch the result |
printf("autocommit is: %s\n" | printf("autocommit is: %s\n" | ||
"0 = off\n1 = on\n", row[0]); | "0 = off\n1 = on\n", row[0]); |