Is it possible to connect MySQL database with c code, if yes then how?

Question

Is it possible to connect database with c code, if yes then how?

If possible share the sample code for connecting to a MySQL database and run a sample query....

Answer 1

The answer is definitely yes. An example for connecting to MySQL with C is below:

 #include <mysql.h>
 #include <stdio.h>
 main() 
 {
     MYSQL *conn;
     MYSQL_RES *res;
     MYSQL_ROW row;
     char *server = "localhost";
     char *user = "root";
     char *password = "PASSWORD";  /* set me first */
     char *database = "mysql";
     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));
        exit(1);
     }
     /* send SQL query */
     if (mysql_query(conn, "show tables")) 
     {
        fprintf(stderr, "%s\n", mysql_error(conn));
        exit(1);
     }
     res = mysql_use_result(conn);
     /* output table name */
     printf("MySQL Tables in mysql database:\n");
     while ((row = mysql_fetch_row(res)) != NULL)
     {
     printf("%s \n", row[0]);
     }         
     /* close connection */
     mysql_free_result(res);
     mysql_close(conn);
}