Error 1005 Errno 150
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings mysql error 1005 errno 150 and policies of this site About Us Learn more about Stack Overflow error code 1005 mysql errno 150 the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation
Mysql Error 1005 Hy000
Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it
Mysql Error 1005 Can't Create Table
only takes a minute: Sign up MySQL Foreign Key Error 1005 errno 150 up vote 31 down vote favorite 8 I'm doing a small DataBase with MySQL Workbench. I have a main table, called "Immobili", which has a Primary Key composed by four columns: (Comune, Via, Civico, Immobile). Now, I also have three other tables, wich have the same primary key mysql error 1005 errno 121 (Comune, Via, Civico, Immobile), but these fields are also referenced to the table Immobili. First question: Can I make a Primary Key that is also a Foreign Key? Second Question: When I try to export the changes it says: Executing SQL script in server # ERROR: Error 1005: Can't create table 'dbimmobili.condoni' (errno: 150) CREATE TABLE IF NOT EXISTS `dbimmobili`.`Condoni` ( `ComuneImmobile` VARCHAR(50) NOT NULL , `ViaImmobile` VARCHAR(50) NOT NULL , `CivicoImmobile` VARCHAR(5) NOT NULL , `InternoImmobile` VARCHAR(3) NOT NULL , `ProtocolloNumero` VARCHAR(15) NULL , `DataRichiestaSanatoria` DATE NULL , `DataSanatoria` DATE NULL , `SullePartiEsclusive` TINYINT(1) NULL , `SullePartiComuni` TINYINT(1) NULL , `OblazioneInEuro` DOUBLE NULL , `TecnicoOblazione` VARCHAR(45) NULL , `TelefonoTecnico` VARCHAR(15) NULL , INDEX `ComuneImmobile` (`ComuneImmobile` ASC) , INDEX `ViaImmobile` (`ViaImmobile` ASC) , INDEX `CivicoImmobile` (`CivicoImmobile` ASC) , INDEX `InternoImmobile` (`InternoImmobile` ASC) , PRIMARY KEY (`ComuneImmobile`, `ViaImmobile`, `CivicoImmobile`, `InternoImmobile`) , CONSTRAINT `ComuneImmobile` FOREIGN KEY (`ComuneImmobile` ) REFERENCES `dbimmobili`.`Immobile` (`ComuneImmobile` ) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `ViaImmobile` FOREIGN KEY (`ViaImmobile` ) REFERENCES `dbimmobili`.`Immobile` (`ViaImmobile` ) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `CivicoImmobile` FOREIGN KEY (`CivicoImmobile` ) REFERE
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn
Error 1005 Archeage
more about Stack Overflow the company Business Learn more about hiring developers or error 1005 iphone posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community error 1005 access denied Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up MySQL error 1005 errno 150 Foreign key constraint is http://stackoverflow.com/questions/4063141/mysql-foreign-key-error-1005-errno-150 incorrectly formed up vote 0 down vote favorite I have created the following tables: Stops: CREATE TABLE Stop ( routeNo DECIMAL (4,0) UNSIGNED, stopNo DECIMAL(3,0) UNSIGNED, latitude DECIMAL(19,16), longitude DECIMAL(19,16), CONSTRAINT PK_Location PRIMARY KEY (routeNo, stopNo), CONSTRAINT FK_stop_location FOREIGN KEY (latitude,longitude) REFERENCES Location(latitude,longitude), CONSTRAINT FK_stop_route FOREIGN KEY (routeNo) REFERENCES Route(routeNo) ); And the table WorkDay: CREATE TABLE Workday ( theDate DATE PRIMARY KEY, notes VARCHAR(30) ); I then http://stackoverflow.com/questions/34074739/mysql-error-1005-errno-150-foreign-key-constraint-is-incorrectly-formed try to create the table Order Delivery with the following code: CREATE TABLE OrderDelivery ( routeNo DECIMAL(4,0) UNSIGNED, stopNO DECIMAL(3,0) UNSIGNED, orderNo INT(9), CONSTRAINT pk_Orders PRIMARY KEY (routeNo, stopNo, orderNo), deliveryDateExpected DATE, deliveryTime TIME, customerName VARCHAR(40), creditCardNo CHAR(16) NOT NULL, customerRanking ENUM('platinum','gold','occasional','one-off'), CONSTRAINT fk_Routes FOREIGN KEY (routeNo) REFERENCES Stop(routeNo), CONSTRAINT fk_Stops FOREIGN KEY (stopNo) REFERENCES Stop(stopNo), CONSTRAINT fk_Dates FOREIGN KEY (deliveryDateExpected) REFERENCES Workday(theDate) ); However every time i try to create the OrderDelivery table it gives the error that the foreign key is incorrectly formed "SQL Error (1005): Can't create table 'harry.OrderDelivery' (errno:150)Foreign key constraint is incorrectly formed" How can i rectify this? mysql share|improve this question asked Dec 3 '15 at 19:40 HarAdams 92 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote You can't create a foreign key to a table with a multiple primary key referencing only one field of that primary key. So your problem lies here: CONSTRAINT fk_Routes FOREIGN KEY (routeNo) REFERENCES Stop(routeNo), CONSTRAINT fk_Stops FOREIGN KEY (stopNo) REFERENCES Stop(stopNo), You should change it to CONSTRAINT fk_Stops_Routes FOREIGN KEY (routeNo, stopNo) REFERENCES Stop(routeNo, stopNo), Or depending on your requirements you have to change your model to fit your needs. share|improve this ans
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta http://dba.stackexchange.com/questions/80435/mysql-create-table-shows-error-1005-errno-150 Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills error 1005 and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Mysql Create table shows ERROR 1005 errno 150 up vote 0 down vote favorite I am trying to make mysql error 1005 a junction table, but I getting a ERROR 1005 errno 150 CREATE TABLE 61furiousFistPokemon( cardNumber int NOT NULL PRIMARY KEY, pokemonName VARCHAR(12), type VARCHAR(10), stage VARCHAR(10), evolvesFrom VARCHAR(12), HP INT, retreatCost INT, weakness VARCHAR(10), weaknessAmount VARCHAR(5), resistance VARCHAR(5), resistanceAmount VARCHAR(5) ); CREATE TABLE cardTags ( tagId int NOT NULL AUTO_INCREMENT PRIMARY KEY, tagName VARCHAR(60) NOT NULL ); CREATE TABLE 61furiousFistPokemonTags ( tagId int NOT NULL AUTO_INCREMENT PRIMARY KEY, pokemonCardNumber int, tagName VARCHAR(60), FOREIGN KEY (pokemonCardNumber) REFERENCES 61furiousFistPokemon(cardNumber), FOREIGN KEY (tagName) REFERENCES cardTags(tagName) ); Any help would be greatly appreciated. mysql innodb foreign-key table share|improve this question edited Oct 17 '14 at 15:23 RolandoMySQLDBA 107k15138274 asked Oct 17 '14 at 3:43 user50479 add a comment| 3 Answers 3 active oldest votes up vote 1 down vote tagName column in table cardTags is not defined as primary key and you are declaring foreign key FOREIGN KEY (tagName) REFERENCES cardTags(tagName). share|improve this answer answered Oct 17 '14 at 8:13 Nawaz Sohail 611214 Although you did not provide a solution, +1 for revealing root ca