Jump to content

MySQL error number 150


subuntug

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...