Add additional tables to the test database in MySQL. Use show tables and describe tablename to confirm what you have done.
Create a source file to insert several records into the tables. Use select queries to confirm what you have done.
Add additional tables to the test database in Access.
Insert records into the tables. Make up a query in design view making use of two tables.
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.
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.
In Access, change the values of fields in existing records, and add new records. Remember to save your work.
Go online and find out about the other data types supported by MySQL and Access.