shelter Posted February 19, 2012 Report Share Posted February 19, 2012 consulta SQL:CREATE TABLE `cep_loc` (`chave_local` int( 11 ) NOT NULL AUTO_INCREMENT ,`nome_local` varchar( 60 ) default NULL ,`cep8_local` varchar( 10 ) default NULL ,`uf_local` varchar( 10 ) default NULL ,PRIMARY KEY ( `chave_local` ) ,KEY `uf_local` ( `uf_local` ) ,CONSTRAINT `cep_loc_ibfk_1` FOREIGN KEY ( `uf_local` ) REFERENCES `estados` ( `str_uf` )) ENGINE = InnoDB AUTO_INCREMENT =9959 DEFAULT CHARSET = latin1;Mensagens do MySQL : Documentação#1005 - Can't create table '.\b2stok\cep_loc.frm' (errno: 150) Quote Link to comment Share on other sites More sharing options...
0 Deivid_hf Posted February 22, 2012 Report Share Posted February 22, 2012 (edited) Amigo tem um link que fala sobre este erro e mostra os possíveis equívocos que você pode ter cometido. Dê uma olhada:Mysql error 1005Abraço! Edited February 22, 2012 by Deivid_hf Quote Link to comment Share on other sites More sharing options...
Question
shelter
consulta SQL:
CREATE TABLE `cep_loc` (
`chave_local` int( 11 ) NOT NULL AUTO_INCREMENT ,
`nome_local` varchar( 60 ) default NULL ,
`cep8_local` varchar( 10 ) default NULL ,
`uf_local` varchar( 10 ) default NULL ,
PRIMARY KEY ( `chave_local` ) ,
KEY `uf_local` ( `uf_local` ) ,
CONSTRAINT `cep_loc_ibfk_1` FOREIGN KEY ( `uf_local` ) REFERENCES `estados` ( `str_uf` )
) ENGINE = InnoDB AUTO_INCREMENT =9959 DEFAULT CHARSET = latin1;
Mensagens do MySQL : Documentação
#1005 - Can't create table '.\b2stok\cep_loc.frm' (errno: 150)
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.