I entered Create table Horse( ID smallint auto increment, RegisteredName varchar(15) not null, Breed varchar(20), Height decimal (3,1), Birthdate date, Contraint Horse Pk primary key (ID), Contraint Horse Check check(Breed in ('Egyptian Arab','holsieiner','Quarter Horse','Paint','Saddlebred')), Contraint Horse Check Height check(height 10 0 and Height '2015 01 01')) Horse table structure describe horse feedback ERROR 1064 (42000) at line 1 You have an error in your SQL syntax check the manual that corresponds to your MySQL server version for the right syntax to use near 'Horse Pk primary key (ID), Contraint Horse Check check(Breed in ('Egyptian Arab'' at line 8 What am I doing wrong Liz

The Answer is in the image, click to view ...

Question: I entered: Create table Horse( ID smallint auto_increment, RegisteredName varchar(15) not null, Breed varchar(20), Height decimal (3,1), Birthdate date, Contraint Horse_Pk primary key (ID), Contraint

I entered: Create table Horse( ID smallint auto_increment, RegisteredName varchar(15) not null, Breed varchar(20), Height decimal (3,1), Birthdate date, Contraint Horse_Pk primary key (ID), Contraint Horse_Check check(Breed in ('Egyptian Arab','holsieiner','Quarter Horse','Paint','Saddlebred')), Contraint Horse_Check_Height check(height>=10.0 and Height<=20.0), Contraint Horse_Check_Birthdate check(birthdate >= '2015-01-01')); /Horse table structure*/ describe horse; feedback: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Horse_Pk primary key (ID), Contraint Horse_Check check(Breed in ('Egyptian Arab'' at line 8

What am I doing wrong? Liz

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

As part of your audit of receivables, you performed a cut-off test of sales. Results revealed the following: 1. Recorded sales in December 2019 Selling price Cost P 18,000 P 16,500 FOB Shipping point...

I need help please, Create a Horse table with the following columns, data types, and constraints. NULL is allowed unless 'not NULL' is explicitly stated. ID - integer with range 0 to 65 thousand,...

3.11 LAB - Update rows in Horse table The Horse table has the following columns: . ID - integer, auto increment, primary key - RegisteredName - variable-length string - Breed - variable-length...

I can't pinpoint exactly where my issue is. Could I get some help on how to correct my statement? Create a Horse table with the following columns, data types, and constraints. NULL is allowed unless...

PART 1: ALREADY COMPLETED. NEED PART 2 Tasks Query Description SQL Statement Create a new database in MySQL called horsestable. List the databases in MySql. Result set should look like: Create...

I keep running into errors in my SQL code The Horse table has the following columns: - ID - integer, auto increment, primary key - RegisteredName - variable-length string - Breed - variable-length...

Students: Section 2 . 6 is a part of 1 assignment Unit 2 Lab Assignment Requirements: zyLab No due date 2 . 6 LAB - Create Horse table with constraints Create a Horse table with the following...

zy Section 3 . 7 - BIS 2 4 5 : Database Essentials for Business with Lab | zyBooks - = zyBooks My library > BIS 2 4 5 : Database Essentials for Business with Lab home > zyBooks catalog Help / FAQ...

Create Horse table with constraints 3 . 7 LAB - Create Horse table with constraints Create a Horse table with the following columns, data types, and constraints. NULL is allowed unless 'not NULL' is...

Create Horse table with constraints Create a Horse table with the following columns, data types, and constraints. NULL is allowed unless 'not NULL' is explicitly stated. ID - integer with range 0 to...

3 . 1 0 LAB - Create Horse table with constraints Create a Horse table with the following columns, data types, and constraints. NULL is allowed unless 'not NULL' is explicitly stated. ID - integer...

LJ, married, has two dependent minor brothers. He is a partner of a general professional partnership. He is also engaged in trading business of his own. The following data were provided by LJ in...

1) reflect on your own experience which lines in this poem are meaningful to you? 2) summarize the main message of this poem 3) what is your opinion of the message of this poem? agree? disagree?...

Consider a diversifed conglomerate such as Alphabet Inc. ( Google ' s parent companyl. which operates in search advertining, cloud computing, autonomous vehicles ( Waymol . and other unrelated...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...