|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
August 5th, 2007, 03:49 AM
|
|||
|
|||
|
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
August 5th, 2007, 10:39 AM
|
||||||
|
||||||
|
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 |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
