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 (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
Get step-by-step solutions from verified subject matter experts
