首先创建一个数据库和表,如下所示:
下面是C/C++代码
#include
#include
#include
#include
#pragma comment(lib,"libmysql")
int my_insert(MYSQL *conn)
{
const char *sql = "insert into `students`"
" values(null,'xiaobai',default)";
int ret = mysql_query(conn, sql);
if (ret != 0)
{
printf("error:%s\n", mysql_error(conn));
getchar();
exit(1);
}
my_ulonglong affected_row = mysql_affected_rows(conn);
printf("%d rows affected.\n", (int)affected_row);
return 0;
}
int main()
{
if (mysql_library_init(0, NULL, NULL))
{
printf("could not initialize MySQL library\n");
getchar();
exit(1);
}
MYSQL conn;
mysql_init(&conn);
MYSQL *ret = mysql_real_connect(&conn, "127.0.0.1", "root", "123456", "test_1", 0, NULL, 0);
if (!ret)
{
printf("Failed to connect to database:%s\n", mysql_error(&conn));
getchar();
exit(1);
}
my_insert(&conn);
mysql_close(&conn);
getchar();
return 0;
}
最后是运行结果: