今天,碰巧有人问,说写的代码server_init,老是失败,我不信,试了一番,大费周折,总算成功。
有兴趣的,不妨自己动手一试,蛮有意思的。
我机器上原本有一个解压缩版的MySQL5.0.9,位于D:/program/mysql-5.0.9-beta-win32,默认存储引擎是InnoDB
1. 为便于测试,首先建立一个测试表,并插入几条记录,引擎定为MyISAM
create table t2(id int primary key, col2 varchar(32)) engine=MyISAM;
2. 创建Embed Server的配置文件,
D:/program/mysql-5.0.9-beta-win32/Embedded/my.ini,值得一提的是,差点把我害惨了,就是Server那一项的名字必须与你的Server程序的名字保持一致。这里,EmbedMySQLServer就是我后边的exe程序的名,否则server永远也启不来。
内容如下:
[EmbedMySQLServer]
basedir = D:/program/mysql-5.0.9-beta-win32
datadir = D:/program/mysql-5.0.9-beta-win32/data
language = D:/program/mysql-5.0.9-beta-win32/share/english
skip-innodb
port=3306
[libmysqld_client]
language = D:/program/mysql-5.0.9-beta-win32/share/english
port=3306
3. 开始写自己的代码了
create EmbedMySQLServer.exe, source code like:
// #define _WIN32_WINNT 0x0400
#include <windows.h>
#include <stdio.h>
#include <stdlib.h>
#include <stdarg.h>
#include "mysql.h"
MYSQL *mysql;
MYSQL_RES *results;
MYSQL_ROW record;
#pragma comment(lib, "D://program//mysql-5.0.9-beta-win32//Embedded//DLL//debug//libmysqld.lib")
static char *server_options[] = { "mysql_test", "--defaults-file=D:/program/mysql-5.0.9-beta-win32/Embedded/my.ini" };
int num_elements = sizeof(server_options)/ sizeof(char *);
static char *server_groups[] = { "EmbedMySQLServer", "libmysqld_client" };
int main(void)
{
int ret = mysql_server_init(num_elements, server_options, server_groups);
printf("return %ld/n", ret);
mysql = mysql_init(NULL);
mysql_options(mysql, MYSQL_READ_DEFAULT_GROUP, "libmysqld_client");
mysql_options(mysql, MYSQL_OPT_USE_EMBEDDED_CONNECTION, NULL);
MYSQL* t = mysql_real_connect(mysql, NULL,"test","test", "test", 0,NULL,0);
mysql_query(mysql, "SELECT id, col2 FROM t2");
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;
}
4. 最终运行结果:
return 0
1 - test
2 - test
3 - test
4 - test
5 - fdas
Press any key to continue
像这类东东,MySQL Online Doc都没好好说,它都推荐买它的商业license,看来自己多动动手,也蛮有意思的。
分享到:
相关推荐
有关状态机设计方面的书籍,我这里隆重推荐一本:《Practical Statecharts in C/C++ Quantum Programming for Embedded Systems》,中文名叫做《嵌入式系统的微模块化程序设计-实用状态图C/C++实现》,北航出版的,...
c/c++嵌入式系统编程 programming embedded systems in c/c++ 适合入门以后提高的人看
嵌入式系统的微模块化程序设计:实用状态图C/C++实现 英文版本
一个关于Microtec公司C/C++编译器的资料。 Embedded developers need a set of compiler tools that can take C, C++, or assembly language, and produce reliable code for their embedded target. What's also ...
经典的嵌入式C编程教材,详细描述了嵌入式开发的流程、嵌入式系统硬件(处理器、存储器、外围设备)及外设驱动编程、嵌入式操作系统描述
非常好的资料:基于嵌入式处理器的C/C++编程&UML设计技术
Eclipse IDE for C/C++ Developers 配置WINDOWS下的C/C++开发环境 操作说明
Eclipse IDE for Embedded C/C++ Developers(eclipse-embedcpp-2022-06-R-win32-x86_64.zip) 适用于Windows x86_64: An IDE for Embedded C/C++ developers. It includes managed cross build plug-ins (Arm and ...
However, if you have some programming experience and are familiar with C or C++, you're ready to learn how to write embedded software. The hands-on, no-nonsense style of this book will help you get ...
这篇资料详细分析了如何在嵌入式系统中编写安全,健壮的 c/c++代码
mqtt linux paho.mqtt.embedded-c-master.zip软件包
/usr/local/webserver/mysql/bin/mysql_install_db --basedir=/usr/local/webserver/mysql --datadir=/data0/mysql/3306/data --user=mysql vi /data0/mysql/3306/my.cnf 输入 [client] character-set-server = utf...
C/C++牛人Dan Sakes关于Volatile用法的总结。 Dan Saks is one of the world's leading experts on the C and C++ programming languages and their use in developing embedded systems. He provides training and ...
嵌入式控制系统及其C、C++实现--面向使用MATLAB的软件开发者
一个将基于Chromium的浏览器嵌入其他应用程序的简单框架。 Chromium嵌入式框架(CEF)是用于在其他应用程序中嵌入基于Chromium的浏览器的简单框架。 快速链接项目页面-https://bitbucket.org/chromiumembedded/cef...
Embedded
嵌入式开发圣经,嵌入式开发必读数据,正在学习中,与大家分享,共同提高。
Practical UML Statecharts in C/C++:Event-Driven Programming for Embedded Systems,Second Edition 官网http://www.state-machine.com/psicc2/index.php