linux c++连接mysql

来源:互联网 发布:php array indexof 编辑:程序博客网 时间:2024/05/19 16:20
#include <cstdio>#include <mysql.h>#include <string>int main(){MYSQL mysql;if (!mysql_init(&mysql)){printf("mysql_init failed!\n");return 0;}if (mysql_real_connect(&mysql, "localhost", "root", "321", "mysql", 0, "/usr/local/mysql/mysql.sock", 0)){printf("connect success!\n");std::string sql = "insert into test values ('hello', 123456);";if (mysql_query(&mysql, sql.c_str())){printf("insert success!\n");}mysql_close(&mysql);}else{printf("connect failed!\n");if (mysql_errno(&mysql)){fprintf(stderr, "Connection error %d: %s\n", mysql_errno(&mysql),mysql_error(&mysql));}}printf("hello from testmysql!\n");    return 0;}