Suppose this file is also named gosei. To pass the data to a MySQL table, one would write. mysql> load data infile "gosei" into table gosei; Then a query result should look like Table 2. Table 2.

MySQL JS> \? ext.schema NAME schema - Schema management and utilities. SYNTAX ext.schema DESCRIPTION A collection of schema management tools and related utilities that work on schemas FUNCTIONS ...

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 ...