MYSQL help needed !!

[Jack_Sparrow]

MYSQL help needed !!

mee query ekee weraddak tiyanawalune
ERROR 1064 (42000)

foreign key dana heti MYSQL site eket tiyenne ee wdiyata

CREATE TABLE score
(
  reviewingid integer,
  questionnumber integer,
  score integer,
 [B]FOREIGN KEY (reviewingid) REFERENCES reviewing (reviewingid) on delete cascade
);[/B]

on delete cascade
demmat oya error ekamai enne

 

[rosharavinda]

CMD eke ena error ekanam enne "marks integer" keyana thana "," eka nathi nisai.
anith eka
FOREIGN KEY keyana eka thaniyama use karanna ba aliase ekak hadanna one.a keyanne
FOREIGN KEY fk1(reviewingid) REFERENCES reviewing (reviewingid) on delete cascade

 

[Jack_Sparrow]

CMD eke ena error ekanam enne "marks integer" keyana thana "," eka nathi nisai.
anith eka
FOREIGN KEY keyana eka thaniyama use karanna ba aliase ekak hadanna one.a keyanne
FOREIGN KEY fk1(reviewingid) REFERENCES reviewing (reviewingid) on delete cascade

foreign key wala awulak neee mama karaaa

adow sirawata , eka
oka dekke nee aluten okkoma gehuwa mama aluten gehuwa okkoma ethakota thama weda kalee bt , uba kiyanakan dekke nee thanks bro
rep ++