MySQL: Essential Skills

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

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?

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

What does the following command accomplish?

LOAD DATA INFILE