Diseño Físico
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
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.