Please provide the cmakelists.txt and simple cpp you used for testing.

int main()
{
std::cout << PROJECT_SOURCE_DIR << std::endl;

// -------------------------------------------mysql示例-------------------------------------------

auto config = std::make_shared<sqlpp::mysql::connection_config>();
config->user = "root";
config->password = "zhanghl";
config->database = "db";
config->host = "127.0.0.1";
config->port = 3306;
config->debug = true;
mysql::connection db(config);

db.execute("CREATE TABLE IF NOT EXISTS test_table (id INTEGER PRIMARY KEY, name VARCHAR(255))");

db.execute("INSERT INTO test_table (id, name) VALUES (1, 'Kimi')");
return 0;

}

add_executable(${TGT} ${DIR_SRCS})

target_compile_definitions(${TGT} PRIVATE -DPROJECT_SOURCE_DIR="${CMAKE_SOURCE_DIR}")

set_target_properties(${TGT} PROPERTIES LINKER_LANGUAGE CXX)

[cmake] sqlpp11 provides CMake targets:

[cmake]

[cmake] find_package(Sqlpp11 CONFIG REQUIRED COMPONENTS MySQL)

[cmake] target_link_libraries(main PRIVATE sqlpp11::mysql)

find_package(fmt CONFIG REQUIRED)
target_link_libraries(${TGT} PRIVATE fmt::fmt)

find_package(Sqlpp11 CONFIG REQUIRED COMPONENTS MySQL)
target_link_libraries(${TGT} PRIVATE sqlpp11::mysql)

Can you post your C++ code? I don't know which header files you referenced.

I change this:#include <mysql/mysql.h>,cmake successed!
but build error
:[build] E:\develop\candcpp\cmakedemo\out\build\cmakemsvcvcpkg\vcpkg_installed\x64-windows-static-md\include\sqlpp11/mysql/bind_result.h(325,51): error C2589: “(”:“::”右边的非法标记 [E:\develop\candcpp\cmakedemo\out\build\cmakemsvcvcpkg\cvv\src\ssqlpp11\test\ssqlpp11_test.vcxproj]
[build] E:\develop\candcpp\cmakedemo\out\build\cmakemsvcvcpkg\vcpkg_installed\x64-windows-static-md\include\sqlpp11/mysql/bind_result.h(325): error C2062: 意外的类型“unknown-type” [E:\develop\candcpp\cmakedemo\out\build\cmakemsvcvcpkg\cvv\src\ssqlpp11\test\ssqlpp11_test.vcxproj]
[build] E:\develop\candcpp\cmakedemo\out\build\cmakemsvcvcpkg\vcpkg_installed\x64-windows-static-md\include\sqlpp11/mysql/bind_result.h(325,1): error C2059: 语法错误:“)” [E:\develop\candcpp\cmakedemo\out\build\cmakemsvcvcpkg\cvv\src\ssqlpp11\test\ssqlpp11_test.vcxproj]
[build] E:\develop\candcpp\cmakedemo\out\build\cmakemsvcvcpkg\vcpkg_installed\x64-windows-static-md\include\sqlpp11/mysql/bind_result.h(326,1): error C2143: 语法错误: 缺少“;”(在“{”的前面) [E:\develop\candcpp\cmakedemo\out\build\cmakemsvcvcpkg\cvv\src\ssqlpp11\test\ssqlpp11_test.vcxproj]
[build] E:\develop\candcpp\cmakedemo\out\build\cmakemsvcvcpkg\vcpkg_installed\x64-windows-static-md\include\sqlpp11/mysql/bind_result.h(326,90): error C2143: 语法错误: 缺少“;”(在“}”的前面) [E:\develop\candcpp\cmakedemo\out\build\cmakemsvcvcpkg\cvv\src\ssqlpp11\test\ssqlpp11_test.vcxproj]
[proc] 命令“"C:\Program Files\CMake\bin\cmake.EXE" --build E:/develop/candcpp/cmakedemo/out/build/cmakemsvcvcpkg --config Debug --”已退出，代码为 1
[driver] 生成完毕: 00:00:07.613

above error code :
std::numeric_limits::max()
std::numeric_limits::max()
such as error to many
“unknown-type” [E:\develop\candcpp\cmakedemo\out\build\cmakemsvcvcpkg\cvv\src\ssqlpp11\test\ssqlpp11_test.vcxproj]MSVC(C2062)
template<> class std::numeric_limits

help me! thinks!!!