• 20 hours
  • Medium

Free online content available in this course.



Got it!

Last updated on 3/6/20

Update records

Log in or subscribe for free to enjoy all this course has to offer!

The next part of CRUD is UPDATE! In phpMyAdmin, select the  dog  table as usual, and make sure that the Browse tab is highlighted. Then click the "Edit" button to the left of a row, and change the dog's name.

Here is the SQL that got generated when I did the update:

UPDATE `dog` SET `name` = 'Mustard' WHERE `dog`.`dog_id` = 1;

I'll rewrite it with line breaks like this:

UPDATE `dog`
SET `name` = 'Mustard'
WHERE `dog`.`dog_id` = 1;

The SQL keywords to perform the update are  UPDATE  and  SET.

Updating multiple records

You can write SQL to update multiple rows of a table.  We could change the SQL above to this:

UPDATE `dog`
SET `name` = 'Catsup'
WHERE `dog`.`dog_id` > 0;

This SQL statement will change all the dogs' names to Catsup!

In the  WHERE  clause, I am asking the database to perform this operation on each dog's whose  dog_id  is greater than zero. That would be all the dogs!

So watch out - SQL is powerful and fast, and there is no undo key.

As you can see,  UPDATE  is pretty straightforward.  Erasing records is also not very complicated, and that's what comes next!


Example of certificate of achievement
Example of certificate of achievement