|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
1005 syntax error
Hi, im getting 1005 error whn running 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 `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`)); |
|
#2
|
||||
|
||||
|
Looks like you are using backticks (`) instead of single quotes ('). Try changing that.
__________________
This is my code. Is it not nifty? "The biggest problem encountered while trying to design a system that was completely foolproof, was, that people tended to underestimate the ingenuity of complete fools." ---Douglas Adams Join the Itsacon fanclub! Zero Tolerance: Spammers banned so far: 278
![]() |
![]() |
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > 1005 syntax error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|