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 21st May 2009.

INSERT INTO Students VALUES
(1230, "Joe", "Frazer", 21/05/2009)