linux mysql 开发环境

安装mysql
sudo apt-get install mysql-servel-5.0 mysql-client-5.0
下载安装过程中，会提示输入root密码
安装C语言编程接口：
 sudo apt-get install libmysqlclient15-dev
更多api 查看：http://dev.mysql.com/doc/refman/5.0/en/c.html
相关mysql头文件和库文件安装在/usr/include/mysql/和/usr/lib/mysql目录
 g＋＋ -g xxx.cpp -I /usr/include/mysql -L /usr/lib/mysql -l mysqlclient  -o xxx
#include <iostream>
#include <mysql.h>
using namespace std;
int main()
{
        MYSQL *mysql;
        mysql = mysql_init(0);
        MYSQL_RES* result;
        MYSQL_ROW row;
        if(!mysql_real_connect(mysql,"localhost" , "root" , "root" , "mydb" , 3309 , NULL , 0))
        {
                cout<<"connect mysql server failed!"<<endl;
                return -1;
        }
        else
        {
                cout<<"connect success!"<<endl;
        }
        mysql_set_character_set(mysql , "gbk");
        string sql = "select * from test";
        int status = mysql_query(mysql , sql.c_str());
        if(status != 0)
        {
            &nb