 |
|
คือแบบว่าถ้าทำเป็นforeign keyหลายๆอันเชื่อมโยงถึงหลายๆตาราง มันไม่ยอมให้สร้างตารางให้อะครับ จะมีวิธีแก้ยังไงบ้างอ่ะครับ
Code (PHP)
CREATE TABLE `redetailTB` (
`id_reserve` int(4) NOT NULL,
`id_room` int(3) NOT NULL,
`checkin` int(4) NOT NULL,
`checkout` int(4) NOT NULL,
PRIMARY KEY (`id_reserve`, `id_room`, `checkin`, `checkout`),
FOREIGN KEY (`id_reserve`) REFERENCES reserveTB (`id_reserve`) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (`id_room`) REFERENCES reroomTB (`id_room`) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (`checkin`) REFERENCES inoutTB (`checkin`) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (`checkout`) REFERENCES reserveTB (`checkout`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB;
Tag : PHP, MySQL
|
|
|
 |
 |
 |
 |
| Date :
2010-08-13 15:10:59 |
By :
DaDachan |
View :
1228 |
Reply :
4 |
|
 |
 |
 |
 |
|
|
|
|
 |
