最近遇到这个问题,看了许多其它相关配置文章,都不够简洁。对于刚入手vscode的人来说不够友好,因此,写下这篇博客,希望能帮助到大家。
这篇文章说明了怎么配置mysql,以及怎么解决可能会遇到的编码问题。注意:本文假设已经配置好了g++等其它环境,同时也安装了合适的mysql。
1.配置两个json文件:c_cpp_properties.json和tasks.json
打开vscode,按下ctrl+shit+p,如下,选择编辑C/C++配置,会自动创建一个c_cpp_properties.json文件
2.打开cmd,输入where mysql
得到mysql的安装路径,如下图,选择bin之前的路径:C:\Program Files\MySQL\MySQL Server 8.0.
3.将include路径输入c_cpp_properties.json中
如下:
代码:
{
"configurations": [
{
"name": "Win32",
"includePath": [
"${workspaceFolder}/**",
"C:\\Program Files\\MySQL\\MySQL Server 8.0\\include" //(添加)此处为mysql安装路径下的include文件夹
],
"defines": [
"_DEBUG",
"UNICODE",
"_UNICODE"
],
"compilerPath": "D:\\g++\\msys64\\ucrt64\\bin\\g++.exe",
"cStandard": "c17",
"cppStandard": "c++17",
"intelliSenseMode": "windows-gcc-x64"
}
],
"version": 4
}
4.配置tasks.json文件
主要添加如下三行:
{
"tasks": [
{
"type": "cppbuild",
"label": "C/C++: g++.exe build active file",
"command": "D:/g++/msys64/ucrt64/bin/g++.exe",
"args": [
"-fdiagnostics-color=always",
"-g",
"${file}",
"-lws2_32",
"-o",
"${fileDirname}/${fileBasenameNoExtension}.exe",
"-I","C:\\Program Files\\MySQL\\MySQL Server 8.0\\include", // mysql的头文件路径
"-L", "C:\\Program Files\\MySQL\\MySQL Server 8.0\\lib", // lib
"-llibmysql" //
],
"options": {
"cwd": "${fileDirname}"
},
"problemMatcher": [
"$gcc"
],
"group": {
"kind": "build",
"isDefault": true
},
"detail": "Task generated by Debugger."
}
],
"version": "2.0.0"
}
5.将libmysql.dll放到你的cpp同文件夹下面
至此,配置完成。接下来说一下可能遇到的乱码问题:
在增加删除修改时添加:
mysql_query(con, "set names gbk");
在读取时
mysql_query(con, "set names utf8");