Exercises, Questions, and Projects


  1. Add additional tables to the test database in MySQL. Use show tables and describe tablename to confirm what you have done.

  2. Create a source file to insert several records into the tables. Use select queries to confirm what you have done.

  3. Add additional tables to the test database in Access.

  4. Insert records into the tables. Make up a query in design view making use of two tables.

  5. Using the general description of SQL statements in the previous chapter, use the SQL alter statement to add a new field called category to the catalog database in MySQL. Use describe catalog to confirm what you have done.

  6. Assuming your description fields were similar to the ones here, use the SQL update statement to change the description fields to omit the “simple” and “intermediate” terms, and put that information into the category field.

  7. In Access, change the values of fields in existing records, and add new records. Remember to save your work.

  8. Go online and find out about the other data types supported by MySQL and Access.




Creating Database Web Applications with PHP and ASP
Creating Database Web Applications with PHP and ASP (Charles River Media Internet & Web Design)
ISBN: 1584502649
EAN: 2147483647
Year: 2005
Pages: 125
Authors: Jeanine Meyer

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net