MySQL MariaDB 语法错误

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,

这是我在 mySQL 中运行 SQL 代码时得到的结果。怎么了？语法对我来说看起来不错。

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))

Answer 1

列或表名称不应包含在撇号中:

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))