c,#include,#include,,int main() {, MYSQL *conn;, MYSQL_RES *res;, MYSQL_ROW row;,, char *server = "localhost";, char *user = "root";, char *password = "your_password"; /* set me first */, char *database = "testdb";,, conn = mysql_init(NULL);,, if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) {, fprintf(stderr, "%s\n", mysql_error(conn));, return 1;, },, if (mysql_query(conn, "show tables")) {, fprintf(stderr, "%s\n", mysql_error(conn));, return 1;, },, res = mysql_use_result(conn);,, printf("MySQL Tables in mysql database:\n");, while ((row = mysql_fetch_row(res)) != NULL), printf("%s \n", row[0]);,, mysql_free_result(res);, mysql_close(conn);,, return 0;,},
``,,这段代码展示了如何连接到MySQL数据库并执行一个简单的查询来显示数据库中的表。Powered By Z-BlogPHP 1.7.3
Copyright Your WebSite.Some Rights Reserved.