Question
Answered step-by-step

 Insert rows into Horse tableIDRegisteredNameBreedHeightBirthDate

  •  - integer, auto increment, primary key
  •  - variable-length string 
  •  - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred
  •  - decimal number, must be between 10.0 and 20.0
  •  - date, must be on or after Jan 1, 2015

                        Insert the following data into the Horse table:

RegisteredName           Breed                      Height                    BirthDate

Babe                               Quarter House          15.3                     2015-02-10

Independence                Holsteiner                 16.0                      2011-03-13

Ellie                                Saddlebred                15.0                      2016-12-22

NULL                             Egyptian Arab           14.9                       2019-10-12


My Sql


CREATE table horse(

     ID smallint(5) unsigned AUTO_INCREMENT,

     RegisteredName VARCHAR(15),

     Breed VARCHAR(20) CHECK (Breed in ('Egyptian Arab', 'Holsteiner', 'Quarter Horse', 'Paint', 'Saddlebred')),

     Height DECIMAL(3,1) CHECK (Hieght >=10.0 and Hieght <=20.0),

     BirthDate date CHECK ( BirthDate >01/01/2015),

     primary key (ID)

     );



INSERT INTO Horse (RegisteredName, Breed, Height, BirthDate) VALUES

("Babe", "Quarter House", 15.3, 2015-02-10),

("Independence", "Holsteiner", 16.0, 2011-03-13),

("Ellie", "Saddlebred", 15.0, 2016-12-22),

(Null, "Egyptian Arab", 14.9, 2019-10-12);


Result set test


Query failed: ERROR 1292 (22007) at line 11: Incorrect date value: '2003' for column 'BirthDate' at row 1

Answer & Explanation
Verified Solved by verified expert
Rated Helpful
<p>consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lore</p> Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet

Unlock full access to Course Hero

Explore over 16 million step-by-step answers from our library

Subscribe to view answer

te, dat, ultrices ac magna. Fus

ctum vitae odio. Donec aliquet. Lorem ipsum do, ultrices ac magna. Fusce dui le

a molestie consequat, ultrices ac magna. Fusce dui lectus, congu

s a molestie consequat, ultrices ac

e vel laoreet ac, dict


s a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dict

Step-by-step explanation

cing elit. Nec facour lae vel laoreet ac, dictum vitaleoipsum doxxreet, consfacilisis. Pellentesque dapibus efficitur laoreet. Na molexaminia pulvinar tortor nec facila molexFresusac, dictsuo.llentesque dapionac, dictum vonllentesque dapionipiscionsum dolor siipsum dolor sit amet, consectetunec faxutcresusamet, conseac,oe vat, ultriciniarem ipsum dolor sit amet, consecteec aosusacinia pulvinatutuac,nec facilisis. Pellentesque dapsumo.lerisus ante, dapibus a molestim ipsuoac,molestie consequat, ultrices ac magna. Fusce dui leac, dim rior neconentesque dapibuone veonllentesque dat, ulmolestie consonia pulvinaronng eoncing elit. Nat, ultricesonnec facilionm rions a molestieat, ulametona. Fusce dui lon, conet, consectec

Student reviews
50% (2 ratings)

"Thank you. Good job. The only error is in typing, House for Horse This was the syntax error."