1. 代码编写
#include <stdlib.h>
#include <stdio.h>
#include " mysql.h "
int main( int argc, char *argv[])
{
MYSQL my_connection;
int res;
mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, " localhost ", " root ", " mysql ", " mysql ", 0, NULL, 0))
{
printf( " Connection success\n ");
res = mysql_query(&my_connection, " INSERT INTO children(fname, age) VALUES('david', 8) ");
if (!res)
{
printf( " Inserted %lu rows\n ", (unsigned long)mysql_affected_rows(&my_connection));
}
else
{
fprintf(stderr, " Insert error %d: %s\n ", mysql_errno(&my_connection),
mysql_error(&my_connection));
}
mysql_close(&my_connection);
}
else
{
fprintf(stderr, " Connection failed\n ");
if (mysql_errno(&my_connection))
{
fprintf(stderr, " Connection error %d: %s\n ",
mysql_errno(&my_connection), mysql_error(&my_connection));
}
}
return EXIT_SUCCESS;
}
#include <stdio.h>
#include " mysql.h "
int main( int argc, char *argv[])
{
MYSQL my_connection;
int res;
mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, " localhost ", " root ", " mysql ", " mysql ", 0, NULL, 0))
{
printf( " Connection success\n ");
res = mysql_query(&my_connection, " INSERT INTO children(fname, age) VALUES('david', 8) ");
if (!res)
{
printf( " Inserted %lu rows\n ", (unsigned long)mysql_affected_rows(&my_connection));
}
else
{
fprintf(stderr, " Insert error %d: %s\n ", mysql_errno(&my_connection),
mysql_error(&my_connection));
}
mysql_close(&my_connection);
}
else
{
fprintf(stderr, " Connection failed\n ");
if (mysql_errno(&my_connection))
{
fprintf(stderr, " Connection error %d: %s\n ",
mysql_errno(&my_connection), mysql_error(&my_connection));
}
}
return EXIT_SUCCESS;
}
2. 插入前
3. 运行结果