SQL

MySQL insert into examble

INSERT INTO Customers (CustomerName, City, PostalCode, Country)
VALUES ('Ali','Dubai','58063','UAE'), 
       ('Akshay','Kochi','695311','India'),
       ('Chan','Xining','S-896 23','China');

MySQL insert

# multiple rows to insert
INSERT INTO tbl_name (a,b,c)
    VALUES(1,2,3), (4,5,6), (7,8,9);

insert mysql

INSERT INTO tbl_name (a,b,c) 
    VALUES(1,2,3), (4,5,6), (7,8,9);

MySQL insert

INSERT INTO tbl_name (col1,col2) VALUES(15,col1*2);