Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started