c语言操作mysql基础

相关函数定义在mysql.h头文件中
MYSQL *     STDCALL mysql_init(MYSQL *mysql);
//mysql初始化原型 参数mysql句柄 返回初始化的句柄


MYSQL *     STDCALL mysql_real_connect(MYSQL *mysql, const char *host,
                       const char *user,
                       const char *passwd,
                       const char *db,
                       unsigned int port,
                       const char *unix_socket,
                       unsigned long clientflag);
//mysql创建连接原型后两个参数一般为NULL和0;连接成功返回非0(mysql * 句柄)；失败返回NULL。


void mysql_close(MYSQL *mysql);//关闭与mysql服务的连接,释放内存；


-----------------------------------------------------------------------------------------
int mysql_query(MYSQL *mysql,const char *query);
//对指定的连接进行查询,成功返回0,出错返回非0。query为传入的mysql语句 
int mysql_real_query(MYSQL *mysql, const char *query, unsigned int length)
//只能查询单个语句,包含二进制的数据(可能包含\0字符),只能用这个查询,成功返回0,出错返回非0。
mysql_query() cannot be used for statements that contain binary data; you must use mysql_real_query() instead. (Binary data may contain the “\0” character, which mysql_query() interprets as the end of the statement string.) In addition, mysql_real_query() is faster than mysql_query() because it does not call strlen() on the s