Question: I'm trying to create a table in MariaDB which is a fork of mySQL. I'mg getting a syntax error. Does anyone know what I am

I'm trying to create a table in MariaDB which is a fork of mySQL. I'mg getting a syntax error. Does anyone know what I am inputting incorrectly? Thumbs up if you can find it.
CentOSx64 [Runningl - Oracle VM VirtualBox File Machine View Input Devices Help asdl' at line3 ERROR 1064 42000): 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'fkjaslkd 4884' at line1 MariaDB [CNU INFORMATION] CREATE TABLE UariationC -) ariant_id BINARY(16) PRIMARY KEY, -> analysis_id BINARYC16) FOREIGN KEY, - chromosome STRING, -> start position INTC(64), -> end_position INT(64), cny type STRING, comparator STRING, copy_number INT, ERROR 1064 42000): 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 'FOREIGN KEY, chromosome STRING start_position INT (64), end_position INT 64) cn' at line 3 MariaDB [CNU INFORMATION] CREATE TABLE Variation -) ariant_id BINARY(16) PRIMARY KEY, -> analysis_id BINARYC16) FOREIGN KEY, - chromosome STRING, -> start position INTC(64), -> end_position INT(64), cny type STRING, comparator STRING, copy_number INT, ERROR 1064 42000): 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 'FOREIGN KEY, chromosome STRING start_position INT (64), end_position INT 64) cn' at line 3 MariaDB [CNUINFORMATION] - CentOSx64 [Runningl - Oracle VM VirtualBox File Machine View Input Devices Help asdl' at line3 ERROR 1064 42000): 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'fkjaslkd 4884' at line1 MariaDB [CNU INFORMATION] CREATE TABLE UariationC -) ariant_id BINARY(16) PRIMARY KEY, -> analysis_id BINARYC16) FOREIGN KEY, - chromosome STRING, -> start position INTC(64), -> end_position INT(64), cny type STRING, comparator STRING, copy_number INT, ERROR 1064 42000): 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 'FOREIGN KEY, chromosome STRING start_position INT (64), end_position INT 64) cn' at line 3 MariaDB [CNU INFORMATION] CREATE TABLE Variation -) ariant_id BINARY(16) PRIMARY KEY, -> analysis_id BINARYC16) FOREIGN KEY, - chromosome STRING, -> start position INTC(64), -> end_position INT(64), cny type STRING, comparator STRING, copy_number INT, ERROR 1064 42000): 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 'FOREIGN KEY, chromosome STRING start_position INT (64), end_position INT 64) cn' at line 3 MariaDB [CNUINFORMATION]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
