Answered

At Westonci.ca, we make it easy to get the answers you need from a community of informed and experienced contributors. Connect with a community of experts ready to help you find accurate solutions to your questions quickly and efficiently. Get precise and detailed answers to your questions from a knowledgeable community of experts on our Q&A platform.

The Horse table has the following columns:

ID - integer, auto increment, primary key
RegisteredName - variable-length string
Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred
Height - decimal number, must be between 10.0 and 20.0
BirthDate - date, must be on or after Jan 1, 2015
Insert the following data into the Horse table:

RegisteredName Breed Height BirthDate
Babe Quarter Horse 15.3 2015-02-10
Independence Holsteiner 16.0 2017-03-13
Ellie Saddlebred 15.0 2016-12-22
NULL Egyptian Arab 14.9 2019-10-12

Sagot :

MrRoyal

See below for the statement to insert the data values

How to insert the records?

To do this, we make use of the insert statement.

This is done using the following syntax:

INSERT INTO table_name (column_name, ...) VALUES (value, ...)

Using the above syntax and the data values, we have the following insert statement.

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

VALUES ('Babe Quarter', 'Horse', '15.3', '2015-02-10'), ('Independence', 'Holsteiner', '16.0', '2017-03-13'), ('Ellie', 'Saddlebred', '15.0', '2016-12-22')

INSERT INTO Horse (Breed, Height, BirthDate) VALUES ('Egyptian Arab', '14.9','2019-10-12')

Read more about SQL at:

https://brainly.com/question/10097523

#SPJ1

We appreciate your time. Please come back anytime for the latest information and answers to your questions. Thanks for using our platform. We aim to provide accurate and up-to-date answers to all your queries. Come back soon. Thank you for trusting Westonci.ca. Don't forget to revisit us for more accurate and insightful answers.