MySQL 8 Cookbook

Inserting

The INSERT statement is used to create new records in a table:

mysql> INSERT IGNORE INTO `company`.`customers`(first_name, last_name,country)VALUES ('Mike', 'Christensen', 'USA'),('Andy', 'Hollands', 'Australia'),('Ravi', 'Vedantam', 'India'),('Rajiv', 'Perera', 'Sri Lanka');

Or you can explicitly mention the id column, if you want to insert the specific id:

mysql> INSERT IGNORE INTO `company`.`customers`(id, first_name, last_name,country)VALUES (1, 'Mike', 'Christensen', 'USA'),(2, 'Andy', 'Hollands', 'Australia'),(3, 'Ravi', 'Vedantam', 'India'),(4, 'Rajiv', 'Perera', 'Sri Lanka');Query OK, 0 rows affected, 4 warnings (0.00 sec)Records: 4 Duplicates: 4 Warnings: 4

IGNORE: If the row already exists and the IGNORE clause is given, ...