Insert Data in MySQL Database | Coding Tag

Insert Data in MySQL Database

Last Updated by Pooja Chikara 13-Mar-20

0 1429


As you read, How to Create Data. Now there is insertion Syntax after creating DATABASE. 'INSERT' statement is used to insert data into table.

MySQL Insert Data Syntax:

INSERT INTO table_name
(column1, column2, column3)
VALUES
(value1, value2, value3);

Where table_name is the name of table in which we want to insert data and column1, column2 and column3 is the name of the fields in the table table_name and value1, value2 and value3 are the values of the particular columns.

Example:

<?php
$conn=mysqli_connect("localhost","root","","databasename");
$sql="INSERT INTO student(name, emailid, city) VALUES('Vihaan','vihaan@codingtag.com','Delhi')";
// student is table name
$result=mysqli_query($conn,$sql);
if ($result)
{
echo "Record Created Successfully";
}
else
{
echo "Insertion Failed";
}
?>


Share:


Discount Coupons



Leave a Reply


Comments
    Waiting for your comments