A-level Computing 2009/AQA/Problem Solving, Programming, Operating Systems, Databases and Networking/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