Get up to speed on MySQL basics with this step-by-step tutorial on how to create a database, add a table, and input data into the table.

Those commands were piped in via STDIN and executed much like the -e command you used to create the initial database. The end result is that you have a database called "food" on your local MySQL ...

Inserting a string into a MySQL table is a matter of logging into the MySQL server, then issuing an "insert" command for the table column that holds text data.

Warnings PhpMyAdmin exports all fields in a table to CSV. Use the MySQL command line to output a subset of fields in a table to CSV.