forum.lissyara.su

Код: Выделить всё

CREATE TABLE IF NOT EXISTS `Orders` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `OrderDate` int(11) DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

CREATE TABLE IF NOT EXISTS `HostingOrders` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `OrderID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `HostingOrdersOrderID` (`OrderID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

ALTER TABLE `HostingOrders`
  ADD CONSTRAINT `HostingOrdersOrderID` FOREIGN KEY (`OrderID`) REFERENCES `Orders` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;

Код: Выделить всё

NULL,NULL

Код: Выделить всё

insert into `HostingOrders` VALUES (NULL,2);

Код: Выделить всё

#1452 - Cannot add or update a child row: a foreign key constraint fails (`h9357_support`.`HostingOrders`, CONSTRAINT `HostingOrdersOrderID` FOREIGN KEY (`OrderID`) REFERENCES `Orders` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE)

Код: Выделить всё

lor=> CREATE TABLE orders (order_id integer PRIMARY KEY, OrderDate integer);
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "orders_pkey" for table "orders"
CREATE TABLE
lor=> create table hosting_orders(id integer primary key, order_id integer references orders);
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "hosting_orders_pkey" for table "hosting_orders"
CREATE TABLE
lor=> insert INTO hosting_orders values(1,2);
ERROR:  insert or update on table "hosting_orders" violates foreign key constraint "hosting_orders_order_id_fkey"
DETAIL:  Key (order_id)=(2) is not present in table "orders".