Kaip įterpti kelis įrašus vienu INSERT INTO sakiniu?

Question

Kaip įterpti kelis įrašus vienu  INSERT INTO  sakiniu?

Answer

INSERT INTO Employees (first_name, last_name, salary) VALUES ('John', 'Smith', 2500), ('Dan', 'Brown', 3000);

Answer

INSERT INTO Employees (first_name, last_name, salary) ('John', 'Smith', 2500), ('Dan', 'Brown', 3000);

Answer

INSERT INTO Employees (first_name, last_name, salary) VALUES ('John', 'Smith', 2500); ('Dan', 'Brown', 3000);

Answer

INSERT INTO Employees VALUES ('John', 'Smith', 2500) ('Dan', 'Brown', 3000);

Crowdly