Database Reference
In-Depth Information
4. Create a table named
birds_least
in the
rookery
database. It should have
four columns:
scientific_name
,
common_name
,
family_name
, and
order_name
. Load this table with data from the
little-birds.csv
you generated
in the previous exercise, using the
LOAD DATA INFILE
statement. This may
be a little tricky. If you don't do it right, delete the data in the import table and
load it again until you get the values in the right columns.