64,643
社区成员
发帖
与我相关
我的任务
分享
MYSQL m_connection;
bool ReadUrl()
{
mysql_init(&m_connection);
mysql_real_connect(&m_connection, "127.0.0.1", "root", "111","test",0,NULL,CLIENT_FOUND_ROWS);
mysql_query(&m_connection, "set names gb2312");
char sql[1024] = "select idcraw, tagname from craw where tagname != \"\"";
MYSQL_RES *results;
if (!mysql_query(&m_connection, sql))
{
results = mysql_store_result(&m_connection);
MYSQL_ROW row;
while (row = mysql_fetch_row(results))
{
std::string tagname(row[1]);
sprintf(sql,"update craw set tagname = 'new' where idcraw = '%s'",res.c_str(),row[0]);
if(!mysql_query(&m_connection, sql)) //执行失败
{
char err[1024];
sprintf(err,"Error %u:%s",mysql_errno(&m_connection),mysql_error(&m_connection));
cout<<"mysql_query failed:"<<err;
}
}
}
return true;
}
MYSQL m_connection;
bool ReadUrl()
{
mysql_init(&m_connection);
mysql_real_connect(&m_connection, "127.0.0.1", "root", "111","test",0,NULL,CLIENT_FOUND_ROWS);
mysql_query(&m_connection, "set names gb2312");
char sql[1024] = "select idcraw, tagname from craw where tagname != \"\"";
MYSQL_RES *results;
if (!mysql_query(&m_connection, sql))
{
results = mysql_store_result(&m_connection);
MYSQL_ROW row;
while (row = mysql_fetch_row(results))
{
std::string tagname(row[1]);
std::string res = tagname;//为去掉中间空格之后是字符串
sprintf(sql,"update craw set tagname = '%s' where idcraw = '%s'",res.c_str(),row[0]);
if(!mysql_query(&m_connection, sql)) //执行失败
{
char err[1024];
sprintf(err,"Error %u:%s",mysql_errno(&m_connection),mysql_error(&m_connection));
cout<<"mysql_query failed:"<<err;
}
}
}
return true;
}