Page 19: More ALTER
Here's the projekts table, which needs some help:
| number | descriptionofproj | contractoronjob |
|---|---|---|
| 1 | outside house painting | Murphy |
| 2 | kitchen remodel | Valdez |
| 3 | wood floor installation | Keller |
| 4 | roofing | Jackson |
This table is in need of a major makeover. How would you rename it to project_list (page 205)?
mysql>Now try ALTERing project_list as described on pages 210-215.
mysql>