- 论坛徽章:
- 0
|
5可用积分
#include <stdio.h>
#include <stdlib.h>
#include <unistd.h>
#include <time.h>
#include "/usr/local/mysql/include/mysql/mysql.h"
int main(void) {
const char *host = "localhost";
const char *user = "root";
const char *pass = "123";
const char *db = "snort1";
char *ccc;
MYSQL mysql;
MYSQL_RES *rs;
MYSQL_ROW row;
mysql_init(&mysql);
if (!mysql_real_connect(&mysql, host, user, pass, db, 0, NULL, 0)) {
printf("%s", mysql_error(&mysql));
}
char *sql = "SELECT COUNT(*) AS NUM FROM event WHERE timestamp BETWEEN (NOW()-10) AND NOW()";
for(;1>0; )
{
sleep(1);//奇怪的问题在这里,为什么这里把sleep函数去掉编译就可以正常执行,结果是0,而不去掉,编译可以通过,但是执行没有任何结果.无反应
if (mysql_query(&mysql, sql)!=0) {
printf( "%s", mysql_errno(&mysql), mysql_error(&mysql));
}
rs = mysql_store_result(&mysql);
row = mysql_fetch_row(rs);
ccc=row[0];
printf( "%s--", ccc);
mysql_free_result(rs);
}
mysql_close(&mysql);
return 1;
} |
最佳答案
查看完整内容
回复 1# liu_hacker 不是不成功,应该是输出没显示而已,你在每个printf加一个\n或者,printf加上fflush(stdout)应该就有了
|