今天装了个MySQL网上找别人的代码下来在VC编译,结果没通过,在VC里LIB, INCLUDE, EXECUTE目录都加了
代码如下
#include <stdio.h>
#include <stdlib.h>
#include <stdarg.h>
#include "mysql.h"
MYSQL *mysql;
MYSQL_RES *results;
MYSQL_ROW record;
static char *server_options[] = { "mysql_test", "--defaults-file=my.cnf" };
int num_elements = sizeof(server_options)/ sizeof(char *);
static char *server_groups[] = { "libmysqld_server", "libmysqld_client" };
int main(void)
{
mysql_server_init(num_elements, server_options, server_groups);
mysql = mysql_init(NULL);
mysql_options(mysql, MYSQL_READ_DEFAULT_GROUP, "libmysqld_client");
mysql_options(mysql, MYSQL_OPT_USE_EMBEDDED_CONNECTION, NULL);
mysql_real_connect(mysql, NULL,NULL,NULL, "database1", 0,NULL,0);
mysql_query(mysql, "SELECT column1, column2 FROM table1");
results = mysql_store_result(mysql);
while((record = mysql_fetch_row(results))) {
printf("%s - %s \n", record[0], record[1]);
}
mysql_free_result(results);
mysql_close(mysql);
mysql_server_end();
return 0;
}
网上搜索
http://www.vckbase.com/SYS/script/viewcomment.asp?gclsid=100&itemid=339
摘抄部分
(发表于2005-10-24 10:38:00)
zqh7850430:有两点注意的，：
１，记得加入mysql.h和winsock.h
2,记得在设置里加入libmysql.lib wsock32.lib
然后还记得设置include 和lib文件夹，就可以了
(发表于2006-4-4 18:35:00)
zqh7850430:哦，还有大家把winsock.h
放在mysql.h前面，否则会有sock错误，
(发表于2006-4-4 19:27:00)
网代码里加下面的部分,编译就通过了
#include <WINSOCK2.H>
#pragma comment(lib, "ws2_32.lib")
#include "mysql.h"
#pragma comment(lib, "libmysql.lib")
运行,少一个libmysqld.dll,复制到system32目录下
用MySQL-gui-tools创建一个database1的数据库, 一个表为table1,字段column1,column2都是VARCHAR类型.添加一个记录
运行mysql控制台,GUI不会用.呵呵.输入use database1回车
输入insert into table1(column1,column2) values ('ddd', 'ccc');回车,成功添加一个记录
// mysql_real_connect(mysql, NULL,NULL,NULL, "database1", 0,NULL,0);修改代码,我的用户名root,密码sa
mysql_real_connect(mysql, NULL,"root","sa", "database1", 0,NULL,0);
运行成功
