Fórum Duvida Insert tabela Muitos para Muitos #423950

CREATE TABLE `OrderDetails` (
  `OrderID` int(11) NOT NULL,
  `ProductID` int(11) NOT NULL,
  `UnitPrice` double NOT NULL,
  `Quantity` int(11) NOT NULL,
  `Discount` int(11) DEFAULT NULL,
  KEY `fk_OrderDetails_1_idx` (`OrderID`),
  KEY `fk_OrderDetails_1_idx1` (`ProductID`),
  CONSTRAINT `fk_OrderDetails_Products` FOREIGN KEY (`ProductID`) REFERENCES `Products` (`ProductsID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_OrderDetails_Order` FOREIGN KEY (`OrderID`) REFERENCES `Orders` (`OrdersID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='latin1_swedish_ci'$$

CREATE TABLE `Orders` (
  `OrdersID` int(11) NOT NULL AUTO_INCREMENT,
  `UnitPrice` int(11) NOT NULL,
  `Quantity` int(11) NOT NULL,
  `Discount` double DEFAULT NULL,
  PRIMARY KEY (`OrdersID`),  
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='latin1_swedish_ci'$$

CREATE TABLE `Products` (
  `ProductsID` int(11) NOT NULL AUTO_INCREMENT,
  `ProductName` varchar(35) NOT NULL,
  `SupplierID` int(11) NOT NULL,
  `CategoryID` int(11) NOT NULL,
  `QuantityPerUnity` int(11) NOT NULL,
  `UnitPrice` double NOT NULL,
  `UnitsInStock` int(11) NOT NULL,
  PRIMARY KEY (`ProductsID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='latin1_swedish_ci'$$