[ vux.elfak @ 24.04.2007. 10:56 ] @
Kada sa jednog racunara eksportujem mysql bazu na drugi, prilikom importovanja baze javlja mi se ova greska:



Error

SQL query:

--
-- Constraints for table `glumi`
--
ALTER TABLE `glumi` ADD CONSTRAINT `fg_FK` FOREIGN KEY ( `film` )
REFERENCES `film` ( `broj_filma` ) ,
ALTER TABLE `glumi` ADD CONSTRAINT `fg_FK` FOREIGN KEY ( `film` )
REFERENCES `film` ( `broj_filma` ) ,
ADD CONSTRAINT `gg_FK` FOREIGN KEY ( `glumac` ) REFERENCES `glumac` (
`id_glumca` ) ;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'TABLE `glumi`
ADD CONSTRAINT `fg_FK` FOREIGN KEY (`film`) REFERENCES `film` (`' at line 3



U cemu je problem
[ Tyler Durden @ 24.04.2007. 11:41 ] @
Jesu iste verzije MySQL servera između kojih prebacuješ bazu?
[ vux.elfak @ 24.04.2007. 12:56 ] @
Iste su verzije na oba racunara
[ Dejan Topalovic @ 24.04.2007. 13:56 ] @
Umjesto zareza, stavi ;, pa pokusaj opet.

Dakle:
ALTER TABLE `glumi` ADD CONSTRAINT `fg_FK` FOREIGN KEY ( `film` )
REFERENCES `film` ( `broj_filma` );