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

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

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!