mysql c-api 预处理语句
stmt = mysql_stmt_init(mysql) mysql_stmt_prepare(stmt, "SELECT ?", strlen("SELECT ?")) mysql_stmt_bind_param(stmt, param_bind) mysql_stmt_execute(stmt) mysql_stmt_bind_result(stmt, result_bind) mysql_stmt_store_result(stmt) while (!mysql_stmt_fetch(stmt)) mysql_stmt_close(stmt) stmt = mysql_stmt_init(mysql); mysql_stmt_prepare(stmt, "delete from aaa", strlen("delete from aaa")); mysql_stmt_bind_param(stmt, bind) mysql_stmt_execute(stmt) //修改bind的变量,可执行多次 mysql_stmt_execute(stmt) mysql_stmt_execute(stmt) mysql_stmt_affected_rows(stmt)