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

UPDATE DELETE 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: INSERT INTO crooks VALUES (1234,'Julie', 'female','12/12/1994','Little Maplestead',67) Sometimes we might not want to insert all the fields, some of them might not be compulsory: INSERT INTO crooks (ID, name, town) --specific fields to insert into VALUES (999, 'Frederick', 'Shotley') ID name gender DoB town numScars 1 Geoff male 12/05/1982 Hull 0 2 Jane female 05/08/1956 York 1 3 Keith male 07/02/1999 Snape 6 4 Oliver male 22/08/1976 Blaxhall 2 5 Kelly female 11/11/1911 East Ham 10 6 Marea female 14/07/1940 Wythenshawe 6 1234 Julie female 12/12/1994 Little Maplestead 67 999 Frederick Shotley 1 Exercise: INSERT statements 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 INSERT INTO crooks VALUES (12, 'Gerry', 'male', '13/12/1987', 'Keele', 9) Alternatively you could use the field headings, but this is a little cumbersome: INSERT INTO crooks (name, town, gender, numScars, ID, DoB) VALUES ('Gerry', 'Keele', 'male', 9, 12, '13/12/1987') Using the above data set, write an INSERT statement to create the following person: name: Kelly-Ann gender: female numScars: 1 INSERT INTO crooks (name, gender, numScars) VALUES ('Kelly-Ann', 'female', 1) __INDEX__