Question: Hi so it just keeps giving me the same error message of Query failed: ERROR 1064 (42000) at line 1: You have an error in

Hi so it just keeps giving me the same error message of Query failed: 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 '' at line 6

Create Table 'Horse' ( 'ID' SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, 'RegisteredName' VARCHAR(15) NOT NULL, 'Breed' VARCHAR (20) CHECK (Breed="Egyptain Arab""Holsteiner""Quarter Horse""Paint""Saddlebred", 'Height" DECIMAL(3,1) CHECK(Height between 10.0 AND 20.0), 'BirthDate' DATE CHECK (BirthDate >='2015-01-01')

);

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 Finance Questions!