Task: Learning Journal

Open your Learning Journal by clicking on the image below

Good notes will help you organise and process data and information

Learn It: Insert a new record

• Example 1: To insert a new record into an existing table we use the SQL INSERT INTO statement. The syntax is:

INSERT INTO tableName (column1, column2,...)
VALUES (value1, value2,...)

• For example, to insert a record for a new customer, Mrs T Rush, 78 Oak Ave, Peterborough, 01733873194, 19/04/1974

INSERT INTO Customer(CustID, Title, Initial, Surname, Address, City, Phone, DoB)
       VALUES(C005, "Mrs", "T", "Rush", "78 Oak Ave", "Pboro", "01733873194", "19/04/1974");

• Example 2: To insert a record for a new book, C456, You Care Too Much, Carl Vernon, Self Help, 4, 07/01/2019:

INSERT INTO Books(BookID, Title, Author, Genre, Rating, PublishDate)
        VALUES(C456, "You Care Too Much", "Self Help", "4", "07/01/2019");

SQL- INSERT

• Lets do some more SQL complete the SQL INSERT Tutorial and the exercises using theW3 Schools SQL link below:

• To update an existing record's attribute(s) that meeting a specified condition, we use the SQL UPDATE statement. The syntax is:

UPDATE tableName
SET column1 = value1, column2 = value2, ...
WHERE column = value

• Example: Update the record of CustID C001, Mrs Flowers, who has changed her address to 63 River Way, and her phone number to 01778 886210.

UPDATE Customer
       SET Address = "63 River Way", Phone = "01778 886210"
       WHERE CustID = "C001"

SQL- UPDATE

• Lets do some more SQL complete the SQL UPDATE Tutorial and the exercises using theW3 Schools SQL link below:

Learn It: Delete an existing record

• To delete an existing record from a table that meeting a specified condition, we use the SQL DELETE statement. The syntax is:

DELETE FROM tablename
WHERE column = value

• Example: Delete the record for CustID C004, Ms, P, Jones.

DELETE FROM Customer
WHERE CustID = C004

SQL- DELETE

• Lets do some more SQL complete the SQL DELETE Tutorial and the exercises using theW3 Schools SQL link below:

• Watch the above video and use the link below it to work thr0ugh the tasks in the video with the presenter