The next thing you'll do is look at the data in each table. To do that, you'll use a new command, SELECT, which in interactive mode just shows the data you're "selecting" based on whatever criteria ...

To list the database instances in the MySQL database, specify this command: mysql>show databases. By default, the test database will be listed. To use this database, specify this command: mysql>use ...

Merging tables, called "joining" in MySQL terms, is done by using the MySQL command interface in phpMyAdmin to create a new table. Identify each of the tables in the different tables that you want ...

When running non-interactive MySQL commands one may submit MySQL credentials on the command line (we'll share with you a better option after the break), e.g.: mysql --password=secret --user=username ...