subuntug Posted April 2, 2010 Share Posted April 2, 2010 Hello everybody;I'm newbie in MySQL databases. I create a table with phpmyadmin and each time it returns to me this error:#1005 - Can't create table 'mydb.centres' (errno: 150)Here's my table: CREATE TABLE IF NOT EXISTS `mydb`.`CENTRES` (`idCENTRE` VARCHAR( 45 ) NOT NULL ,`nom` VARCHAR( 45 ) NULL ,`adresse` VARCHAR( 45 ) NULL ,PRIMARY KEY ( `idCENTRE` ) ,INDEX `idFORMATION` ( `idCENTRE` ASC ) ,CONSTRAINT `idFORMATION` FOREIGN KEY ( `idCENTRE` ) REFERENCES `mydb`.`FORMATIONS` (`idFORMATION` ) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE = InnoDB Can you tell me where is my error ?Thank you in advence for your help Link to comment Share on other sites More sharing options...
justsomeguy Posted April 2, 2010 Share Posted April 2, 2010 http://www.google.com/search?client=opera&...-8&oe=utf-8 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.