mysql insert query multiple columns code example

Example 1: insert multiple items in mysql

#Assuming that there is a database called MyDatabase
#The following adds items to a table called TableName with columns No., Age, and class
use MyDatabase;
insert into TableName(No., Name, Age, Class)
values(1, "VinCoD", 21, "4E");

Example 2: update multiple columns in mysql

UPDATE newpurchase 
SET receive_qty = 20, pub_lang = 'Hindi', receive_dt = '2008-07-10' 
WHERE purch_price > 50;