mysql应用程序（linux c++版本）

开发机器是Ubuntu 18.04.3 LTS，先安装mysql开发环境：apt install libmysqlclient-dev

root@yiyouserver:~/XWH/otl# g++ -o mysqltest mysqltest.cpp -I/usr/include/mysql -lmysqlclient
root@yiyouserver:~/XWH/otl# ./mysqltest 192.168.205.1 root mysql55 test
connect success!
OK

#include <stdio.h>
#include <mysql.h>

/*
USE `test`;
DROP TABLE IF EXISTS `test`;

CREATE TABLE `test` (
`Name` VARCHAR(128) DEFAULT NULL,
`ID` VARCHAR(128) DEFAULT NULL
) ENGINE=INNODB DEFAULT CHARSET=utf8;
*/

int main(int argc,char *argv[])
{
if( argc < 5 )
{
printf("Usage: mysqltest Host User Pass DB(eg:./mysqltest 192.168.205.1 root mysql55 test)\n");
return 1;
}
MYSQL conn;
int res;
mysql_init(&conn);
if(mysql_real_connect(&conn,argv[1],argv[2],argv[3],argv[4],0,NULL,CLIENT_FOUND_ROWS))
{
printf("connect success!\n");
res=mysql_query(&conn,"insert into test values('user','123456')");
if(res)
{
printf("error\n");
}
else
{
printf("OK\n");
}
mysql_close(&conn);
}
return 0;
}