Before we start manipulating our table data, let's review our superhero table. It should look like this:
Name | Alias | Power
-----------|----------------|--------------
Superman | Clark Kent | Flight
Spider-Man | Peter Parker | Web-slinging
Iron Man | Tony Stark | Genius Engineer
Let's say we want to update Spider-Man's power to 'Web-slinging and Wall-crawling'. To do this, find the row with Spider-Man, and replace 'Web-slinging' with 'Web-slinging and Wall-crawling' in the 'Power' column. Your table should now look like this:
Name | Alias | Power
-----------|----------------|---------------------
Superman | Clark Kent | Flight
Spider-Man | Peter Parker | Web-slinging and Wall-crawling
Iron Man | Tony Stark | Genius Engineer
Now, let's say we want to remove Iron Man from our table. To do this, simply delete the entire row containing Iron Man's information. Your table should now look like this:
Name | Alias | Power
-----------|----------------|---------------------
Superman | Clark Kent | Flight
Spider-Man | Peter Parker | Web-slinging and Wall-crawling
Let's add two more superheroes to our table. Add the following rows to your table:
Name | Alias | Power
-------------|-----------------|----------------
Wonder Woman | Diana Prince | Super Strength
Batman | Bruce Wayne | Detective Skills
Your table should now look like this:
Name | Alias | Power
-------------|-----------------|---------------------
Superman | Clark Kent | Flight
Spider-Man | Peter Parker | Web-slinging and Wall-crawling
Wonder Woman | Diana Prince | Super Strength
Batman | Bruce Wayne | Detective Skills
You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.