ImplementationINSERT INTO

The INSERT INTO statement is used to add a record to a table.

The original table called 'Pupil' contains the following records:

To add a new record, the following SQL code could be used:

INSERT INTO Pupil

VALUES (0011, Frankie, Al-Robeye, 1M2, Miss Armstrong, 71)

This would return:

Be careful!

If you are only adding data to specific columns/fields, you must specify the column name.

For example, if you were only adding the Pastoral Care Teacher and Merit Points, the SQL would be:

INSERT INTO Pupil (Pastoral Care Teacher, Merit Points)

VALUES (Miss Armstrong, 71);

Some database packages generate values automatically.

In this example the pupilID column may be an ‘autonumber’ field. If this is the case, you do not need to specify a value for the PupilID column.