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]); | ||