A small example of MySQL C programming in Linux

A small example of MySQL C programming in Linux-Linux general technology-Linux programming and kernel information. for details, see the following. To include the header file mysql. h
MYSQL * conn;
MYSQL_RES * res;
MYSQL_ROW row;
Char * server = "localhost ";
Char * user = "root ";
Char * password = "123456 ";
Char * database = "sam ";
Boycott 18:38:36
// Save http packet info
Conn = mysql_init (NULL );
/* Connect to database */
If (! Mysql_real_connect (conn, server, user, password, database, 0, NULL, 0 ))
{
Fprintf (stderr, "% s \ n", mysql_error (conn ));
Return;
}

/* Send SQL query */
Sprintf (insert, "insert into response (HTTP, Date, Server, Cache_Control, Expires, Last_Modified ,\
ETag, Accept_Ranges, Content_Length, Connection, Content_Type, File_Location )\
Values ('% s',' % s ', '% s',' % s ')",
_ Http, _ date, _ server, _ cache_control, _ expires, _ last_modified,
_ Etag, _ accept_ranges, _ content_length, _ connection, _ content_type, file_name );
// Printf ("^ % s ^ \ n", insert );
If (mysql_query (conn, insert )){
Fprintf (stderr, "% s \ n", mysql_error (conn ));
}

Mysql_close (conn );