MySQL MariaDB syntax error

Question

#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 ''Nr_analizes' int NOT NULL, 'AnPacienti_id' int NOT NULL,

This is what I get when I run SQL code in mySQL. What is happening? The sintax looks fine to me.

CREATE TABLE Analiza_laboratorike(
'Nr_analizes' int NOT NULL,
'AnPacienti_id' int  NOT NULL,

 'Lloji_analizes' varchar(15) NOT NULL,
    'Kategoria_pacientit' varchar(15) NOT NULL,
    PRIMARY KEY(Nr_analizes),
    FOREIGN KEY(AnMjeku_id) REFERENCES Mjeku(Mjeku_id),
    Foreign KEY(AnPacienti_id) REFERENCES Pacienti(Pacienti_id))

You use the wrong TICKS ' use a backtick instead ` for the column name — Bernd Buffen
– Bernd Buffen, Commented Feb 13, 2016 at 20:56

Zbynek Vyskovsky - kvr000 · Accepted Answer · 2016-02-13 20:57:16Z

1

Column or tables names shouldn't be enclosed in apostrophes:

CREATE TABLE Analiza_laboratorike(
Nr_analizes int NOT NULL,
AnPacienti_id int  NOT NULL,

Lloji_analizes varchar(15) NOT NULL,
Kategoria_pacientit varchar(15) NOT NULL,
PRIMARY KEY(Nr_analizes),
FOREIGN KEY(AnMjeku_id) REFERENCES Mjeku(Mjeku_id),
Foreign KEY(AnPacienti_id) REFERENCES Pacienti(Pacienti_id))

answered Feb 13, 2016 at 20:57

Zbynek Vyskovsky - kvr000

19.1k3 gold badges41 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bernd Buffen · Accepted Answer · 2016-02-13 20:58:41Z

1

Here the CREATE with back Ticks:

CREATE TABLE Analiza_laboratorike(
`Nr_analizes` INT NOT NULL,
`AnPacienti_id INT  NOT NULL,

 `Lloji_analizes` VARCHAR(15) NOT NULL,
    `Kategoria_pacientit` VARCHAR(15) NOT NULL,
    PRIMARY KEY(Nr_analizes),
    FOREIGN KEY(AnMjeku_id) REFERENCES Mjeku(Mjeku_id),
    FOREIGN KEY(AnPacienti_id) REFERENCES Pacienti(Pacienti_id))

answered Feb 13, 2016 at 20:58

Bernd Buffen

15.1k2 gold badges27 silver badges41 bronze badges

Collectives™ on Stack Overflow

MySQL MariaDB syntax error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related