4,012
社区成员
发帖
与我相关
我的任务
分享
#include <stdio.h>
#include <mysql.h>
#include <mysql_com.h>
#include <mysql_version.h>
#include <my_alloc.h>
#define tableName "article"
main()
{
char mysqlServer[20] = "localhost";
char query[300];
MYSQL *conn;
MYSQL_RES *res;
MYSQL_FIELD *fd;
MYSQL_ROW row;
int rowCount = 0;
int colCount = 0;
int i, j;
conn = mysql_init(NULL);
//连接数据库mysql
if (!mysql_real_connect(conn,"localhost", "root", "876521963", "mydata",3306,NULL,0))
{
printf("connect mysql error!\n");
return 0;
}
//==================================
sprintf(query,"select * from %s",tableName);
if( mysql_query(conn, query) != 0 )
{
printf("query error!\n");
return 0;
}else
{
res = mysql_store_result(conn);
rowCount = (int) mysql_num_rows( res );
colCount = (int) mysql_num_fields( res );
printf(" result: %d records found\n fields: %d \n", rowCount, colCount);
row = mysql_fetch_row( res );
for(i = 0; i < rowCount; i++)
{
printf(" show: ");
for( j = 0; j < colCount; j++)
{
printf("[ %s ] ", row[j] );
} // end for
printf(" \n ");
} // end for
}
mysql_free_result(res); //释放结果集
mysql_close(conn);
//return 0;
}