A Gentle Introduction to

SQL

NEW.

These questions have been submitted by users.



What's the syntax to insert more than 1 row at a time from hardcoded values?
The problem: I have several rows of data to insert into a table and no matter what I do I cannot insert more than 1 row at a time. This works: INSERT INTO EMPLOYEE VALUES (7698, "blake", "Manager", 7839, "5/1/81", 2850, NULL, 30); Adding another line produces a "characters after ;" error VALUES (7782, "clark", "Manager",7839, "6/9/81", 2450, NULL, 10); I tried using commas instead of all but the last semicolon, spaces, repeating INSERT INTO EMPLOYEE For each line. None work. There must be a way to run one SQL and insert multiple rows.

It sounds wierd but that's the way it is.

postgres variations:
None

access
db2
mysql
oracle
postgres
sqlserver