C++MYSQL：使用事务

//1 开始事务
//START TRANSACTION;
sql = "START TRANSACTION";
re = mysql_query(&mysql, sql.c_str());
if (re != 0)
{
	cout << "mysql_query failed! " << mysql_error(&mysql) << endl;
}

//单条语句插入1千条数据
for (int i = 0; i < 1000; i++)
{
	sql = "insert into t_video (name,path) 					   values('single','0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789')";
	re = mysql_query(&mysql, sql.c_str());
	if (re != 0)
	{
		cout << "mysql_query failed! " << mysql_error(&mysql) << endl;
	}
}

//2 设置为手动提交事务，源码中还有autocommit的修改，但是我觉得没必要，已经手动开启事务了
//set autocommit = 0
sql = "set autocommit = 0";
re = mysql_query(&mysql, sql.c_str());
if (re != 0)
{
	cout << "mysql_query failed! " << mysql_error(&mysql) << endl;
}

sql = "COMMIT";
re = mysql_query(&mysql, sql.c_str());
if (re != 0)
{
	cout << "mysql_query failed! " << mysql_error(&mysql) << endl;
}

sql = "set autocommit = 1";
re = mysql_query(&mysql, sql.c_str());
if (re != 0)
{
	cout << "mysql_query failed! " << mysql_error(&mysql) << endl;
}

• C++计时函数的使用

  函数包含在库<chrono>中

  #include<iostream>
  #include<chrono>
  using namespace std;
  using namespace chrono;		//chrono包含在std中，所以想声明std
  
  int main(){
      auto start = system_clock::now();
      func(){...};
      auto end = system_clock::now();
      //利用duration_cast进行类型转换，转换成毫秒
      auto dur = duration_cast<milliseconds>(end - start);
      cout << "执行时间：" << dur.count() <<endl;
  }