A-level Computing/AQA/Paper 2/Fundamentals of databases/INSERT

We might also want to add new things to our database, for example when we are adding new Criminal records or a new friendship link on Facebook. To add new records we use the INSERT command with values of the fields we want to insert: Sometimes we might not want to insert all the fields, some of them might not be compulsory:

Using the above data set, write an INSERT statement to create the following person: name: Gerry town: Keele gender: male numScars: 9 ID: 12 DoB: 13/12/1987

Be careful, you must insert the fields in the order they are specified in the table Alternatively you could use the field headings, but this is a little cumbersome:

Using the above data set, write an INSERT statement to create the following person: name: Kelly-Ann gender: female numScars: 1

__INDEX__