linux下mysql的应用程序_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

#include

/*

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;

}