hi, im getting 1005 error whn running this query ..plz tell wats wrong in this code :?

Question

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 `cus_num` FOREIGN KEY `cus_num`(`cus_num`)
REFERENCES `customer`(`cus_num`),
CONSTRAINT `tour_num` FOREIGN KEY `tour_num`(`tour_num`)
REFERENCES `tour`(`tour_num`));


wats wrong?

Answer 1

try double quotation marks instead of single ones.

Answer 2

It works in my PC. Its fine. Go ahead