sXt2RSEd

1CREATE TABLE IF NOT EXISTS dogs (
2  id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3  breed char(20) NOT NULL,
4  color char(20) NOT NULL,
5  special_skill char(20) DEFAULT NULL
6);
7	
81, 'American Bulldog',  'White', 'Runs fast'
92, 'American Bulldog',  'White',  Null
103, 'American Foxhound', 'White',  Null
114, 'American Foxhound', 'Black',  Null
125, 'American Bulldog',  'Black',  Null
13	
14find by ('American Bulldog',  'White', 'Runs fast')
15Returns id 1
16
17find by ('American Bulldog',  'White')
18Returns id 2
19
20find by ('American Bulldog',  'Black', 'Runs fast')
21Returns id 5