C program to insert data into a table in MySQL database in Linux
All Answers
total answers (1)
Severity: 8192
Message: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated
Filename: libraries/Filtered_db.php
Line Number: 23
total answers (1)
In this program, we will connect to the MyDb database and then insert data into the "Employee" table using the "INSERT INTO" command.
Program/Source Code:
The source code to insert data into a specified table in the MySQL database in Linux is given below. The given program is compiled and executed successfully on Ubuntu 20.04.
Output:
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 the MySql server using the mysql_real_connect() function and then create an "employee" table and insert records into the employee table using mysql_query() function with specified SQL command and then print "Data inserted successfully" message on the console screen.
need an explanation for this answer? contact us directly to get an explanation for this answer