mysql与C语言连接实验报告_纯C语言连接MySql数据库并输出结果

HelloTVM

于 2021-02-18 11:51:56 发布

阅读量169

点赞数

文章标签： mysql与C语言连接实验报告

本文链接：https://blog.csdn.net/weixin_36163782/article/details/114341860

版权

#include

int main() { MYSQL mysql; MYSQL_RES *res; MYSQL_ROW row; char query[1024]; mysql_init(&mysql); if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "aaa", 3306, NULL, 0)) { printf("connect error!/n"); } else { printf("connect success!/n"); strcpy(query," select * from aa;"); mysql_real_query(&mysql,query,(unsigned long)strlen(query)); res=mysql_store_result(&mysql); if(res==NULL) { printf("结果为空/n"); } else { printf("%lu/n/n",(unsigned long)mysql_num_rows(res)); while((row=mysql_fetch_row(res))) { printf("%s/n",row[0]); } } mysql_free_result(res); } mysql_close(&mysql); return 0;}