Example 1
INSERT INTO Students
VALUES
(1229,
"Greg", "Hill",
21/07/2009)
You can add records into a table using the INSERT INTO command.
Example 1 shows a use of the INSERT INTO command.
Example 1
INSERT INTO Students
VALUES
(1229,
"Greg", "Hill",
21/07/2009)
This will add a record at the bottom of the table Students, with the four values
provided as its fields.
Write a SQL command to INSERT another student INTO the Students table, called Joe Frazer, born on 9th March 2009.
Tap/click to reveal
INSERT INTO Students
VALUES
(1230,
"Joe", "Frazer",
09/03/2009)