Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Master The Art Of Data Storytelling With Visualizations

Authors: Alexander N Donovan

1st Edition

B0CNMD9QRD, 979-8867864248

More Books

Students also viewed these Databases questions

Question

Give the entry to pay the total payroll unemployment taxes.

Answered: 1 week ago