CREATE TABLE locations (
locationID int,
location varchar,
customerID int,
PRIMARY KEY (locationID),
FOREIGN KEY (customerID) REFERENCES customers(customerID)
)

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '
customerID int,
PRIMARY KEY (locationID),
FOREIGN KEY (customerID) REFERENCE' at line 3