If you verify the contents of the Sales table using the SELECT statement you can observe the inserted records as shown below в€’ Now, let us insert 3 more records in Sales table. If you pass the values to the INSERT statement in the same order as in the table you can omit the column names в€’ Insert into sales (ID, ProductName, CustomerName, DispatchDate, DeliveryTime, Price, Location) values(1, 'Key-Board', 'Raja', DATE(''), TIME('11:00:00'), 7000, 'Hyderabad')

ExampleДЄssume we have created a table with name Sales in MySQL database using CREATE TABLE statement as shown belowДЇollowing query inserts a row in the above created table в€’ Where, table_name is the name of the table into which you need to insert data, (column1, column2, lumnN) are the names of the columns and (value1, value2, value3.valueN) are the values in the record. INSERT INTO table_name (column1, column2, lumnN) SyntaxДЇollowing is the syntax of the INSERT statement of MySQL.

In this, you need to specify the name of the table, column names, and values (in the same order as column names). You can add new rows to an existing table of MySQL using the INSERT statement.

Php mysql insert sql injection