安装需要使用的库
sudo apt-get install libmysqlclient-dev
头文件
/usr/include/mysql # mysql的头文件在这里
引入头文件
#include"mysql.h"
如果找不到就
#include"mysql/mysql.h"
如果还找不到,并且用的cmake
include_directories(/usr/include/mysql)
链接库
cmake 中加入以下代码
target_link_libraries(AppMain -lmysqlclient)
主要注意-lmysqlclient
测试代码(这代码没试过,看看就行)
#include <cstdio>
#include <iostream>
#include <mysql/mysql.h>
using std::cout;
using std::endl;
int main(int argc, char const *argv[])
{
MYSQL conn;
mysql_init(&conn);
int result;
if (mysql_real_connect(&conn, "127.0.0.1", "root", "123456", "demo1", 3306, NULL, CLIENT_FOUND_ROWS))
{
printf("success");
const char *sql_createDB = "create table `user` (id int primary key,val varchar(99));";
result = mysql_query(&conn, sql_createDB);
if (result)
{
cout<<"写入数据库失败"<<endl;
}else{
cout<<"写入数据库成功"<<endl;
}
mysql_close(&conn);
}else{
cout<<"error"<<endl;
};
return 0;
}
Cmake 代码
cmake_minimum_required(VERSION 1.0)
project(projectname)
include_directories(/usr/include/mysql)
add_executable(runapp srcfile.cpp)
target_link_libraries(runapp -lmysqlclient)
。。。
- 我以为有FindMySQL
- target_link_libraries 可以使用
-lpthread``-lmysqlclient
这种方式引入库