Hands On SQL

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>

< Previous Page

Next Page >