Database Reference
In-Depth Information
(
'Gaviiformes'
,
"Loons"
),
(
'Podicipediformes'
,
"Grebes"
),
(
'Procellariiformes'
,
"Albatrosses, Petrels"
),
(
'Sphenisciformes'
,
"Penguins"
),
(
'Pelecaniformes'
,
"Pelicans"
),
(
'Phaethontiformes'
,
"Tropicbirds"
),
(
'Ciconiiformes'
,
"Storks"
),
(
'Cathartiformes'
,
"New-World Vultures"
),
(
'Phoenicopteriformes'
,
"Flamingos"
),
(
'Falconiformes'
,
"Falcons, Eagles, Hawks"
),
(
'Gruiformes'
,
"Cranes"
),
(
'Pteroclidiformes'
,
"Sandgrouse"
),
(
'Columbiformes'
,
"Doves and Pigeons"
),
(
'Psittaciformes'
,
"Parrots"
),
(
'Cuculiformes'
,
"Cuckoos and Turacos"
),
(
'Opisthocomiformes'
,
"Hoatzin"
),
(
'Strigiformes'
,
"Owls"
),
(
'Struthioniformes'
,
"Ostriches, Emus, Kiwis"
),
(
'Tinamiformes'
,
"Tinamous"
),
(
'Caprimulgiformes'
,
"Nightjars"
),
(
'Apodiformes'
,
"Swifts and Hummingbirds"
),
(
'Coraciiformes'
,
"Kingfishers"
),
(
'Piciformes'
,
"Woodpeckers"
),
(
'Trogoniformes'
,
"Trogons"
),
(
'Coliiformes'
,
"Mousebirds"
),
(
'Passeriformes'
,
"Passerines"
);
As large as that statement was, it inserted only two of the four columns into each row. I
left out
order_id
, which I know will be assigned by the server with a value that starts at
what I asked for, 100, and increments for each row. The default of NULL will be assigned
to the
order_image
column, and we can insert images later if we want. However, we
can't pretend the columns don't exist. If we enter an
INSERT
statement and don't provide
data for one or more of the columns that we specify, MySQL will reject the SQL state-
ment and return an error message like this one:
ERROR 1136 (21S01):
Column count doesn't match value count at row 1
This indicates that we didn't give the server the number of columns it was expecting.
By now, I hope you see why I created a special table dedicated to orders and made it so
you have to enter each name only here, and not on every single bird in the main table.
Given the
bird_orders
table, you can use numbers in the
order_id
column to rep-
resent a bird order in the
bird_families
table. This is one of the benefits of a referen-