第二章 C语言实例 —— Mysql控制
经常用到C语言去控制MYSQL，以下是个人写的我的mysql目录(从网上下载之后直接解包后的目录),最近的Mysql不用进行安装
$ ls /home/zhoubaochuan/mysql-5.5.11-linux2.6-i686/lib/libmysqlclient.a libmysqlclient_r.so libmysqlclient_r.so.18.0.0libmysqlclient.so.18 libmysqld.a libmysqlservices.a pluginlibmysqlclient_r.alibmysqlclient_r.so.18libmysqlclient.so libmysqlclient.so.18.0.0libmysqld-debug.alibtcmalloc_minimal.so$ ls /home/zhoubaochuan/mysql-5.5.11-linux2.6-i686/include/decimal.h m_string.h my_config.hmy_global.h mysql mysql_embed.h my_sys.h plugin.h sslopt-longopts.herrmsg.h my_alloc.h my_dbug.h my_list.h mysql_com.h mysql.h my_xml.h sql_common.h sslopt-vars.hkeycache.hmy_attribute.hmy_dir.h my_net.h mysqld_ername.hmysql_time.h plugin_audit.h sql_state.h typelib.hm_ctype.h my_compiler.h my_getopt.hmy_pthread.hmysqld_error.h mysql_version.hplugin_ftparser.hsslopt-case.h
1.编写main.c
#include <stdio.h>#include <stdlib.h>#include <mysql.h>int main(int argc, char *argv[]){ const char *host = "localhost"; const char *user = "root"; const char *password = ""; const char *db = "mysql"; MYSQL conn; printf("Start Mysql init=====================================\n"); mysql_init(&conn); /* 初始化 */ if (!mysql_real_connect(&conn, host, user, password, db, 0, NULL, 0)){ printf("Open the %s connect is failure!", mysql_error(&conn)); return -1; } printf("Start Mysql query=====================================\n"); /* 查询 */ char *sql = "select * from user"; if (mysql_query(&conn, sql) != 0){ printf("%s \n", mysql_errno(&conn), mysql_error(&conn)); } MYSQL_RES *rs = mysql_store_result(&conn); /* 获取结果 */ MYSQL_ROW row; while(row = mysql_fetch_row(rs)){ /* 一行一行的记录 */ printf("%s===============%s\n",row,row); } mysql_free_result(rs); mysql_close(&conn); return 0;} 2.编写Makefile
CC=gcc1: $(CC) main.c-L/home/zhoubaochuan/mysql-5.5.11-linux2.6-i686/lib -lmysqlclient -I/home/zhoubaochuan/mysql-5.5.11-linux2.6-i686/include -Wl,-rpath,/home/zhoubaochuan/mysql-5.5.11-linux2.6-i686/lib -o mysql3.编译
$ makegcc main.c-L/home/zhoubaochuan/mysql-5.5.11-linux2.6-i686/lib -lmysqlclient -I/home/zhoubaochuan/mysql-5.5.11-linux2.6-i686/include -Wl,-rpath,/home/zhoubaochuan/mysql-5.5.11-linux2.6-i686/lib -o mysql
4.执行代码
$ ./mysql Open the Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) connect is failure! 错误:MYSQL SERVER未启动
5.启动MYSQL SERVER
# /etc/init.d/mysql.server startStarting MySQL [确定] 6.再次执行
$ ./mysql Start Mysql init=====================================Start Mysql query=====================================localhost===============rootzhoubc===============root127.0.0.1===============root::1===============rootlocalhost===============zhoubc===============
页:
[1]