Question: ERROR 1064 HOW TO FIX THIS ERROR: EmployeeID varchar(3), FOREIGN KEY (EmployeeID) REFERENCES Employee (EmployeeID), CustomerId varchar(4), FOREIGN KEY (CustomerId) REFERENCES Customer1(CustomerID) ); ERROR 1064

 ERROR 1064 HOW TO FIX THIS ERROR: EmployeeID varchar(3), FOREIGN KEY

ERROR 1064 HOW TO FIX THIS ERROR:

EmployeeID varchar(3), FOREIGN KEY (EmployeeID) REFERENCES Employee (EmployeeID), CustomerId varchar(4), FOREIGN KEY (CustomerId) REFERENCES Customer1(CustomerID) );

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your Myso L server version for the right syntax to use near 'out date DATE, EmployeeID int FOREIGN KEY (EmployeeID) REFERENCES Employee (Empl' at line 4 mysql> create table Ordersl (OrderlId int PRIMARY KEY, ->in date DATE > out_date DATE, -EmployeeID varchar (3), FOREIGN KEY (EmployeeID) REFERENCES Employee (EmployeeID) ->Customerid varchar (4), FOREIGN KEY (CustomerId) REFERENCES Customerl (CustomerID) ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your Myso L server version for the right syntax to use near 'out_date DATE, EmployeeID varchar (3), FOREIGN KEY (EmployeeID) REFERENCES Employ' at line 4 mysql>

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