Bulk Importing Data - Learning MySQL and MariaDB - page 376

Moorea Sandpiper and range ""extinct;
formerly Moorea (Society Islands)"".",
species,Prosobonia ellisi,Moorea Sandpiper,extinct;
formerly Moorea (Society Islands),
Charadriiformes,Scolopacidae (Sandpipers and Allies)
,1,xxxx,,,addition (2014),,,,,
...
6707,new species,"Robb et al. (2013) describe a new species of owl,
Omani Owl
(Strix omanensis), from the Arabian Peninsula, with range
""central Al Hajar mountains, northern Oman"".
Position Omani Owl immediately following Hume's Owl (Strix
butleri).",
species, inStrix omanensis,Omani Owl,"central Al Hajar mountains,
northern Oman",
Strigiformes,Strigidae (Owls),,,,,addition (2014),,,,,
...
The CSV file contains about 32,000 lines, but I've listed here just a few lines of interest as
a sample. I put hard returns within each record to make them easier to discuss. Each re-
cord in the original file, though, is on one long line without breaks.
The first record gives the field names. Some of the names are a bit confusing, as they refer
to earlier versions of the Clements list for continuity with earlier lists. The first field,
sort 6.9 , is an identification number for each row. The sort 6.8 and sort 6.7
fields you see further down are the identification numbers from those earlier lists. There
are several more fields, but for the examples in this chapter we care only about the Cle-
ments 6.9 change , Scientific name , English name , Order , and Family
fields.
The Clements 6.9 change field indicates the type of change for the bird since the
last Clements list. For the purpose of the scenario we're concerned about now, we want
the new species changes.
The two records containing data are the ones that we want to import. Record 4073 is re-
lated to a new species that was added to the Clements list, the Prosobonia ellisi or Moorea
Sandpiper . Unfortunately, this bird is extinct. Ornithologists collect information on all
known birds, even extinct ones. For good form, we'll add it to the birds table, even
though none of our birdwatchers will see one. Record 6707 shows another new species,
the Strix omanensis or Omani Owl . Fortunately, this owl from the Arabian Peninsula isn't
extinct.