ADVERTISEMENT
ADVERTISEMENT

C program to get records from the MySQL database table in Linux

Here, we are going to write a C program to get records from the MySQL database table in Linux.
Submitted by Nidhi, on February 13, 2021

Prerequisites:

The following packages need to be installed in the ubuntu machine for MySQL connectivity using the C program.

sudo apt install default-libmysqlclient-dev

Problem Solution:

In this program, we will connect to the MyDb database and then retrieve records from the "Employee" table using the "SELECT" command.

Program/Source Code:

The source code to retrieve records from MySql database table in Linux is given below. The given program is compiled and executed successfully on Ubuntu 20.04.

//C program to retrieve records from MySql database 
//table in Linux.

#include <mysql.h>
#include <stdio.h>
#include <string.h>

int main()
{
    char server[16] = "localhost";
    char username[16] = "root";
    char password[16] = "root";
    char database[16] = "MyDb";

    MYSQL* conn = mysql_init(NULL);
    MYSQL_ROW record;

    if (conn == NULL) {
        printf("MySQL initialization failed");
        return 1;
    }

    if (mysql_real_connect(conn, server, username, password, database, 0, NULL, 0) == NULL) {
        printf("Unable to connect with MySQL server\n");
        mysql_close(conn);
        return 1;
    }

    if (mysql_query(conn, "SELECT * FROM Employee")) {
        printf("Unable to connect with MySQL server\n");
        mysql_close(conn);
        return 1;
    }

    MYSQL_RES* rs = mysql_store_result(conn);

    if (rs == NULL) {
        printf("Unable to compile SQL statement\n");
        mysql_close(conn);
        return 1;
    }

    while (record = mysql_fetch_row(rs)) {
        printf("%s %s %s\n", record[0], record[1], record[2]);
    }
    mysql_close(conn);

    return 0;
}

Output:

$ gcc select.c -o select  `mysql_config --cflags --libs`
$ sudo ./select 
[sudo] password for arvind: 
101 KIRAN 10000
102 SUMAN 12000
103 RAMAN 16000

In the above program, we included the mysql.h header file to use MySql connectivity related functions. Here, we created variables server, username, password, and database that are initialized values specific to the MySQL connectivity.

Here, we connected to the MyDb database in MySql server using mysql_real_connect() function and then retrieve records from "employee" table using mysql_query(), mysql_store_result(), and mysql_fetch_row() functions and printed the all employee records on the console screen.

C MySQL Programs »


ADVERTISEMENT



ADVERTISEMENT



Comments and Discussions


ADVERTISEMENT

ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.