MySQL Forums
Forum List  »  Spanish

Diseño Físico
Posted by: Perico Palotes
Date: June 02, 2016 11:23AM

Tengo que crear esta bd , pero nada mas empezar , ya empiezan los errores ...

http://115.imagebam.com/download/YPvESpAhs_63Z_ND9faN0Q/48730/487296680/dise%C3%83%C2%B1ovuelta.jpg

create or replace table caminos
(
nombre varchar(30),
km dec(4,1),
primary key (nombre),
constraint fk_camino foreign key (nombre) references
recorridos (nombre),
constraint fk_caminos foreign key (nombre) references
etapas (nombre)
);

ERROR 1005 (HY000): Can't create table `repaso`.`caminos` (errno: 150 "Foreign key constraint is incorrectly formed")
MariaDB [repaso]>

He probado cambiando el nombre de fk_ con varias combinaciones y posiciones y no hay manera

Options: ReplyQuote


Subject
Views
Written By
Posted
Diseño Físico
946
June 02, 2016 11:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.