Q:

C program to drop a table in MySQL database dynamically in Linux

belongs to collection: C MySQL Programs

0

C program to drop a table in MySQL database dynamically in Linux

All Answers

need an explanation for this answer? contact us directly to get an explanation for this answer

In this program, we will connect to the MyDb database and then drop the "Employee" table dynamically using the "Drop table" command.

Program/Source Code:

The source code to drop a specified table in the MySQL database dynamically in Linux is given below. The given program is compiled and executed successfully on Ubuntu 20.04.

//C program to drop a specified table in 
//MySQL database dynamically 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);

    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, "Drop TABLE Employee")) {
        printf("Unable to create drop table in MyDb database\n");
        mysql_close(conn);
        return 1;
    }

    mysql_close(conn);

    printf("Employee table dropped successfully\n");

    return 0;
}

Output:

$ gcc drop_table.c -o drop_table  `mysql_config --cflags --libs`
$ sudo ./drop_table 
Employee table dropped successfully

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

Here, we connected to the MyDb database in the MySql server using the mysql_real_connect() function and then drop the "employee" table using the mysql_query() function with specified SQL command and then print the "Employee table dropped successfully" message on the console screen.

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

C program to insert data into a table in MySQL dat... >>
<< C program to create a table in MySQL database dyna...