RE:error 1452 mysql - ayuda urgente por favor
Publicado por
Miguel Angel (1 intervención) el 15/10/2021 12:20:56
Tengo ese error pero algo diferente "Error Code: 1452. Cannot add or update a child row: a foreign key constraint fails (`practica4u2`.`venta`, CONSTRAINT `FK_idp` FOREIGN KEY (`id_producto`) REFERENCES `producto` (`id_producto`))"
Ya verifique que los atributos estuvieran en ambas tablas pero ya no encuentro la solucion a este error.
create schema jhg;
use jhp;
create table CLIENTE(
id_cliente int not null,
nombre varchar (60) not null,
direccion varchar (60) not null,
telefono float not null,
ciudad varchar (20) not null,
primary key (id_cliente)
);
select * from CLIENTE;
drop table CLIENTE;
create table PRODUCTO(
id_producto int not null,
descripcion varchar (60) not null,
precio float not null,
primary key (id_producto)
);
select * from PRODUCTO;
drop table PRODUCTO;
create table VENTA(
id_venta int,
cantidad float not null,
primary key (id_venta),
id_cliente int,
id_producto int,
constraint FK_idp foreign key (id_producto) references PRODUCTO (id_producto),
constraint FK_idc foreign key (id_cliente) references CLIENTE (id_cliente)
);
select * from VENTA;
drop table VENTA;
INSERT INTO CLIENTE VALUES(123,'Simon Bolivar', 'Kra11#9-56', '7702291', 'Cali');
INSERT INTO CLIENTE VALUES(456,'Mark Zuckerberg', 'Cll 21#95-52', '57315291', 'Medellin');
INSERT INTO CLIENTE VALUES(789,'Drew Barrymore', 'Kra52#65-05', '3125359456', 'Cali');
INSERT INTO CLIENTE VALUES(741,'Larry Page', 'Cll 05#52-95', '7872296', 'Tunja');
INSERT INTO CLIENTE VALUES(147,'Tom Delonge', 'Cll 52#65-56', '7992293', 'Medellin');
INSERT INTO CLIENTE VALUES(852,'Simon Bolivar', 'Kra 21#65-52', '982295', 'Bogota');
INSERT INTO CLIENTE VALUES(258,'Mark Hoppus', 'Cll 11#95-9', '8952294', 'Bogota');
INSERT INTO CLIENTE VALUES(963,'Britney Spears', 'Cll 05#52-56', '7705295', 'Tunja');
INSERT INTO CLIENTE VALUES(369,'John Forbes Nash', 'Kra 21#05-56', '776622966', 'Cali');
INSERT INTO CLIENTE VALUES(159,'Tom Delonge', 'Kra05#65-05', '6702293','Medellin');
INSERT INTO CLIENTE VALUES(753,'Sergey Brin', 'Cll 11#65-11', '9702299', 'Medellin');
INSERT INTO CLIENTE VALUES(153,'Emma Watson', 'Kra 9#9-95', '31569638', 'Tunja');
INSERT INTO PRODUCTO VALUES(1,'Coca-Cola 2L',2400);
INSERT INTO PRODUCTO VALUES(2,'Doritos',1000);
INSERT INTO PRODUCTO VALUES(3,'Salchicha',3600);
INSERT INTO PRODUCTO VALUES(4,'Pan',500);
INSERT INTO PRODUCTO VALUES(5,'Queso',1000);
INSERT INTO PRODUCTO VALUES(6,'Sandia',8000);
INSERT INTO PRODUCTO VALUES(7,'Leche 1L',4563);
INSERT INTO PRODUCTO VALUES(8,'Atun',1800);
INSERT INTO PRODUCTO VALUES(9,'Pescado',7856);
INSERT INTO PRODUCTO VALUES(10,'Cicla Estatica',1800);
INSERT INTO PRODUCTO VALUES(11,'Camiseta',12000);
INSERT INTO PRODUCTO VALUES(12,'Blue-Jean',7800);
INSERT INTO PRODUCTO VALUES(13,'Papaya',1400);
INSERT INTO PRODUCTO VALUES(14,'Agua en Bolsa',1800);
INSERT INTO PRODUCTO VALUES(15,'Red Bull',1200);
INSERT INTO VENTA (id_venta,cantidad,id_producto,id_cliente) VALUES (1,5,123,1),
(2,6,123,2),
(3,7,123,3),
(4,8,123,4),
(5,2,456,5),
(6,4,741,6),
(7,5,456,7),
(8,600,741,8),
(9,69,852,9),
(10,15,789,10),
(11,11,456,5),
(12,22,789,6),
(13,11,753,7),
(14,10,963,12),
(15,65,963,11),
(16,12,852,10),
(17,65,741,9),
(18,78,147,8),
(19,92,258,9),
(20,12,258,6),
(21,32,147,3),
(22,3,789,1),
(23,45,456,2),
(24,5,123,3),
(25,5,789,4),
(26,6,456,1),
(27,4,123,2),
(28,7,789,12),
(29,8,258,13),
(30,9,852,14),
(31,9,753,15),
(32,6,753,10),
(33,7,159,9),
(34,8,963,10),
(35,9,369,8),
(36,15,369,7),
(37,5,123,5),
(38,6,123,6),
(39,7,123,7),
(40,8,123,8),
(41,5,123,9),
(42,6,123,10),
(43,7,123,11),
(44,8,123,12),
(45,5,123,13),
(46,6,123,14),
(47,7,123,15);