Hello, im getting error 1005 WHN run this query .. plz tell wats wrong in this code:? CREATE TABLE payment_details (
Receipt_num INTEGER (5) NOT NULL,
payment_date DATE NOT NULL
Payment_amount FLOAT NOT NULL,
Cus_num INTEGER (5) NOT NULL,
Tour_num INTEGER (5) NOT NULL,
CONSTRAINT `FOREIGN KEY` cus_num "cus_num` (`cus_num)
REFERENCES "Customer" ("cus_num")
CONSTRAINT `FOREIGN KEY` tour_num "tour_num` (`tour_num)
REFERENCES "Tour" ("tour_num"));
wats wrong?
Try double quotes instead of one.
It works on my PC. Its fine. Go
Posted on March 24, 2010.
