database foreign key error

[Bartb56]

Hey guys i need to make a database for school but it wont let me use a foreign key and i can't find why not pls help

Im working in phpmyadmin.

Code:

create TABLE opdrachten(
    opdrachtnummer int not null PRIMARY KEY,
    werkindustrie varchar(200) not null,
    datum date not null,
    kabelleverancier varchar(30) not null,
    overigewaarnemingen varchar(200) not null,
    handtekening varchar(20) not null,
    aantalbedrijfsuern int not null,
    redenenenVoorAfleggen text not null
);
CREATE TABLE checklisten(
    opdrachtnummer int not null,
    kabelid INT  PRIMARY KEY AUTO_INCREMENT not null,
    Zichtbarekabelbreuk6d varchar(50) not null,
    Zichtbarekabelbreuk30d varchar(50) not null,
    afslijpingvandraden text not null,
    roestcorrosie text not null,
    verminderdediameter text not null,
    positiemeetpunt varchar(200) not null,
    beoordeling varchar(200) not null,
    beschadigingenroestvormtpye varchar(200) not null,
    
    FOREIGN KEY ('opdrachtnummer') REFERENCES opdrachten ('opdrachtnummer')
    ON DELETE CASCADE
    ON UPDATE RESTRICT
);

 

Error:

#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 ''opdrachtnummer') REFERENCES 'opdrachten' ('opdrachtnummer')
)' at line 13

[Alterlai]

Remove the quotes in the foreign key declaration. Like this:

FOREIGN KEY (opdrachtnummer) REFERENCES opdrachten (opdrachtnummer)

 

[Bartb56]

Just now, Alterlai said:

Remove the quotes in the foreign key declaration. Like this:

FOREIGN KEY (opdrachtnummer) REFERENCES opdrachten (opdrachtnummer)

 

thats what i tried first but someone told me to use the quotes

[Bartb56]

haha for some reason it is working now thank you