Module 3 Mastery Check

1. How do you make a copy of the table wolfhounds , including its data?

2. If you have a table called sport and it has the fields football , basketball , soccer , and hockey , how do you make a table called ballgames without the hockey field?

3. What kind of table resides in memory and lasts only as long as the MySQL Client s current connection?

4. What does the following command accomplish?

    LOAD DATA INFILE