如何使用c代码连接阿里云Mysql数据库

更新时间: 2024-02-25 19:23:21作者: 网站编辑阅读量: 149

int main() {

MYSQL *conn;MYSQL_RES *res;MYSQL_ROW row;char *host = "your_host";char *user = "your_user";char *password = "your_password";char *database = "your_database";conn = mysql_init(NULL);if (mysql_real_connect(conn, host, user, password, database, 0, NULL, 0) == NULL) {    fprintf(stderr, "%sn", mysql_error(conn));    return 1;}printf("Connected to MySQL database.n");// 执行SQL查询语句if ((res = mysql_query(conn, "SELECT * FROM your_table")) == NULL) {    fprintf(stderr, "%sn", mysql_error(conn));    return 1;}while ((row = mysql_fetch_row(res)) != NULL) {    printf("%sn", row[0]);}mysql_free_result(res);mysql_close(conn);return 0;

}

```