c语言 mysql update_C语言操作MySQL步骤

友情提示：朋友毕设让帮忙写写伪代码，并不是系统学习，只列取最基本和最常用的API，及其例程。

连接

C语言连接MySQL包含两步：

初始化一个连接句柄

实际进行连接

MYSQL *mysql_init(MYSQL *);

//参数含义可查

MYSQL *mysql_real_connect(MYSQL *connection,

const char *server_host,

const char *sql_user_name,

const char *sql_password,

const char *db_name,

unsigned int port_number,

const char *unix_socket_name,

unsigned int flags);

Ex:

MYSQL *conn_ptr;

conn_ptr = mysql_init(NULL);

if(!conn_ptr)

{

...//mysql_init failed

}

conn_ptr = mysql_real_connect(conn_ptr, "localhost", "rick", "secret", "foo", 0, NULL, 0);

if(conn_ptr)

{

...//connection success

}

else

{

...//connection failed

}

错误处理

char *mysql_error(MYSQL *connection);

unsigned int mysql_errno(MYSQL *connection);

Ex:

MYSQL *conn_ptr;

conn_ptr = mysql_init(NULL);

if(!conn_ptr)

{

...//mysql_init failed

}

conn_ptr = mysql_real_connect(conn_ptr, "localhost", "rick", "secret", "foo", 0, NULL, 0);

if(conn_ptr)

{

...//connection success

}

else

{