各位大虾,小弟在MySQL的DOS界面操作使用INSERT语句能返回OK,但是在VC编程中就执行不了,代码如下:
MYSQL m_mySql;
ULONG flag1,flag2,flag3,flag4;flag1 = mysql_query(&m_mySql, "CREATE DATABASE mydb");
flag2 = mysql_query(&m_mySql, "USE mydb");
flag3 = mysql_query(&m_mySql, "CREATE TABLE student(name TEXT,date TEXT,sex TEXT,re TEXT)");
flag4 = mysql_query(&m_mySql, "INSERT INTO student SET name='Ning', data='1983-11-05', sex='male', re='abc'");调试发现flag1,flag2,flag3都等于0,即语句执行成功,但是在第四条语句时就返回1,执行不成功,请问这是什么问题呢?
MYSQL m_mySql;
ULONG flag1,flag2,flag3,flag4;flag1 = mysql_query(&m_mySql, "CREATE DATABASE mydb");
flag2 = mysql_query(&m_mySql, "USE mydb");
flag3 = mysql_query(&m_mySql, "CREATE TABLE student(name TEXT,date TEXT,sex TEXT,re TEXT)");
flag4 = mysql_query(&m_mySql, "INSERT INTO student SET name='Ning', data='1983-11-05', sex='male', re='abc'");调试发现flag1,flag2,flag3都等于0,即语句执行成功,但是在第四条语句时就返回1,执行不成功,请问这是什么问题呢?
flag = mysql_query(&m_mySql, "INSERT INTO student(name,data,sex,re) VALUES('Ning','1983-11-05','male','abc')");
还是不行,flag依然为1
http://download.csdn.net/source/2680639
http://tieba.baidu.com/f?kz=235037674