#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貢獻(xiàn)1827條經(jīng)驗(yàn) 獲得超8個(gè)贊
$ sudo yum install mysql-devel -y //RHEL,Centos,Fedora $ sudo apt-get install libmysqlclient-dev -y //Ubuntu
如果已經(jīng)安裝成功了，找到mysql.h的文件路徑，-I 編譯即可
$ sudo find /usr/ -name 'mysql.h' $ gcc -I/usr/include/mysql ...
添加回答
舉報(bào)
0/150
提交
取消