c语言操作mysql数据库.doc

1. mysql在linux下的编译和安装rootlocalhost zieckey# mkdir /usr/local/mysqlrootlocalhost zieckey# cp mysql-4.0.12.tar.gz /home/rootlocalhost root# cd /home/解压rootlocalhost home# tar zxvf mysql-4.0.12.tar.gzrootlocalhost home# cd mysql-4.0.12配置，生成Makefilerootlocalhost mysql-4.0.12# ./configure -prefix=/usr/local/mysql -without-debug -with-extra-charsets=gb2312 -enable-assembler -without-isam -without-innodb -with-pthread -enable-thread-safe-client编译rootlocalhost mysql-4.0.12# make安装rootlocalhost mysql-4.0.12# make installrootlocalhost mysql-4.0.12# scripts/mysql_install_db创建一个数据库管理员rootlocalhost mysql-4.0.12# groupadd mysqlrootlocalhost mysql-4.0.12# useradd -g mysql mysql改变权限。rootlocalhost mysql# chown -R root /usr/local/mysqlrootlocalhost mysql# chown -R mysql /usr/local/mysql/varrootlocalhost mysql# chgrp -R mysql /usr/local/mysql配置环境变量，以便于编程rootlocalhost mysql-4.0.12# cd /usr/local/mysql/bin/rootlocalhost bin# export PATH=$PATH:/usr/local/mysql/bin/rootlocalhost bin# export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/mysql/lib/mysql/rootlocalhost bin# env启动mysql服务器rootlocalhost root# cd /usr/local/mysql/bin/rootlocalhost bin# ./mysqld_safe -u mysql&Starting mysqld daemon with databases from /usr/local/mysql/var查看是否启动了rootlocalhost root# pgrep mysql159311595015951启动一个mysql客户端rootlocalhost root# /usr/local/mysql/bin/mysqlWelcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 1 to server version: 4.0.12Type help; or h for help. Type c to clear the buffer.mysql创建一个数据库mysql create database cusemysql;Query OK, 1 row affected (0.00 sec)并使用这个数据库mysql use cusemysql;Database changed在给数据库内创建一个表mysql create table children(childno int not null unique,fname varchar(20),age int);Query OK, 0 rows affected (0.00 sec)在该表内插入一项数据mysql insert into children values(5,花儿,10);Query OK, 1 row affected (0.00 sec)mysql select * from children;+-+-+-+| childno | fname | age |+-+-+-+| 5 | 花儿 | 10 |+-+-+-+1 row in set (0.03 sec)mysql2. 下面进行具体的操作/* insert.c */#include #include #include mysql.h/*注意哦，上面也可以是mysql.h的绝对地址，一般在mysql下的include目录下，仔细看看你的在哪里？*/int main(int argc, char *argv) MYSQL my_connection; int res; mysql_init(&my_connection); /*mysql_real_connect(&mysql,host,user,passwd,dbname,0,NULL,0) = NULL)*/ if (mysql_real_connect(&my_connection, localhost, root, ,cusemysql,0,NULL,CLIENT_FOUND_ROWS) printf(Connection successn); res = mysql_query(&my_connection, insert into children values(11,Anny,5); if (!res) printf(Inserted %lu rowsn,(unsigned long)mysql_affected_rows(&my_connection); /*里头的函数返回受表中影响的行数*/ else /分别打印出错误代码及详细信息 fprintf(stderr, Insert error %d: %sn,mysql_errno(&my_connection),mysql_error(&my_connection); mysql_close(&my_connection); else fprintf(stderr, Connection failedn); if (mysql_errno(&my_connection) fprintf(stderr, Connection error %d: %sn,mysql_errno(&my_connection),mysql_error(&my_connection); return EXIT_SUCCESS;gcc -o insert insert.c -lmysqlclient -I/usr/local/mysql/include