c++ mysql_query 插入路径

Question

c++ mysql_query执行insert时读不了\（\ 这样也不行）怎么解决？
谢谢各位大神了！
我用的是VC，连接数据库用的是mysql的API函数
#include "winsock.h"

#include "mysql.h"

#pragma comment(lib,"libmySQL.lib")

#include "stdio.h"

#include "string.h"

#include

using namespace std;
char sql_query[150];//保存ＳＱＬ语句
MYSQL* mysql_conn_setup(){

MYSQL* mysql=mysql_init(NULL);

if(!mysql_real_connect(mysql,"localhost","root","root","test",0,NULL,0)){

cout<<"connection error";

exit(1);

}

cout<<"connection!"<<endl;
return mysql;

}

void insert(MYSQL* mysql,char sql_query)
{
sprintf(sql_query,"insert into pic values(4,'1.0','zwg2@\oo','1')");
if(mysql_query(mysql,sql_query))
{
cout<<"insert fail!"<<endl;
}
cout<<"insert success!"<<endl;
}
void main(){

MYSQL* mysql;

memset(sql_query,'\0',150);

mysql=mysql_conn_setup();//连接数据库    
 insert(mysql,sql_query); 
mysql_free_result(res);  
mysql_close(mysql);  

}

Answer 1

sql 中不能用 / 用的话指定报错