03-27-2010, 06:16 PM
|
#1 (permalink)
|
|
The Wanderer
Join Date: Mar 2010
Posts: 14
Thanks: 4
|
composite key syntax. How can I fix this?
i wanted to create a table name booking that have 3 composite key where 2
of the composite key is referring to each another table named customer and room.
however when i wanted to create the table, it give me error. can someone tell me
how can i fix this.
Here's the command :
Code:
CREATE TABLE booking(
bookingID INT NOT NULL AUTO_INCREMENT ,
checkin DATETIME,
checkout DATETIME,
nights INT,
totalprice INT,
b_ic_no VARCHAR(30),
b_room_no INT,
PRIMARY KEY ( bookingID) ,
PRIMARY KEY ( b_ic_no ) REFERENCES customer( ic_no ) ,
PRIMARY KEY ( b_room_no ) REFERENCES room( room_no ),
ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE = INNODB;
|
|
|
|
Join the friendly bunch on IRC...
Linear Mode
