Reports

You can insert multiple rows into a table after ensuring that the table is empty by

INSERT INTO Persons
SELECT personID, personName
FROM (
  SELECT 1 as personID, "Jhon" as personName
  UNION ALL
  SELECT 2 as personID, "Steve" as personName
)
WHERE NOT EXISTS (SELECT 1 from Persons);

Where the "UNION ALL" statement is used to combine the result sets of two or more "SELECT" statement

Note: Forpas wrote the solution core here but I edited the syntax to insert multiple rows instead of one

79158050