#include <mysql/mysql.h>MYSQL *conn;MYSQL_RES *res;MYSQL_ROW *row;char *server = "localhost";char *user = "root";char *password = "1";conn = mysql_init(NULL);if(!mysql_real_connect (conn,server,user,password,database,0,NULL,0)){ fprintf(stderr,"%s\n",mysql_error(conn)); exit(1);}if(mysql_real_query(conn,"select * from student")){ fprintf(stderr,"%s\n",mysql_error(conn)); exit(1);}res = mysql_use_result(conn);while((row = mysql_fetch_row(res)) != NULL){ printf("%s\t%s\t%s\n",row[0],row[1],row[2]);}mysql_free_result(res);mysql_close(conn);
2 回答
慕仙森
TA贡献1827条经验 获得超7个赞
$ sudo yum install mysql-devel -y //RHEL,Centos,Fedora $ sudo apt-get install libmysqlclient-dev -y //Ubuntu
如果已经安装成功了,找到mysql.h
的文件路径,-I
编译即可
$ sudo find /usr/ -name 'mysql.h' $ gcc -I/usr/include/mysql ...
添加回答
举报
0/150
提交
取消