[SOLVED] Create table

[anon191]

I'm writing a 'create table' script, but it keeps being rejected by SQL and I'm not sure why, any ideas would be much appreciated!!

 

CREATE TABLE Order_Line
(Order_id INT(4) NOT NULL AUTO_INCREMENT,
username VARCHAR(15) NOT NULL,
print_ida VARCHAR(4) NOT NULL,
print_idb VARCHAR(4) NOT NULL,
print_idc VARCHAR(4) NOT NULL,
Constraint Pk_order Primary Key(Order_id),
INDEX ( username ),
Constraint FK_username FOREIGN KEY (username) REFERENCES Customer( username ) ON DELETE CASCADE)
INDEX ( print_ida ),
Constraint FK_pida FOREIGN KEY (print_ida) REFERENCES Prints( print_id ) ON DELETE CASCADE)
INDEX ( print_idb ),
Constraint FK_pidb FOREIGN KEY (print_idb) REFERENCES Prints( print_id ) ON DELETE CASCADE)
INDEX ( print_idc ),
Constraint FK_pidc FOREIGN KEY (print_idc) REFERENCES Prints( print_id ) ON DELETE CASCADE)
TYPE = INNODB;

 

And I get the error message:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( print_ida ),

Constraint FK_pida FOREIGN KEY (print_ida) REFERENCES Prints( pr' at line 10

 

Please help me!

[anon191]

Anyone?

[Mchl]

Count your parentheses

[anon191]

Yep, done that, but it all looks in order to me  ??? I dont know where I'm going wrong

[Mchl]

You counted wrong then. There are three more ) than (

 

CREATE TABLE Order_Line
(Order_id INT(4) NOT NULL AUTO_INCREMENT,
username VARCHAR(15) NOT NULL,
print_ida VARCHAR(4) NOT NULL,
print_idb VARCHAR(4) NOT NULL,
print_idc VARCHAR(4) NOT NULL,
Constraint Pk_order Primary Key(Order_id),
INDEX ( username ),
Constraint FK_username FOREIGN KEY (username) REFERENCES Customer( username ) ON DELETE CASCADE,
INDEX ( print_ida ),
Constraint FK_pida FOREIGN KEY (print_ida) REFERENCES Prints( print_id ) ON DELETE CASCADE,
INDEX ( print_idb ),
Constraint FK_pidb FOREIGN KEY (print_idb) REFERENCES Prints( print_id ) ON DELETE CASCADE,
INDEX ( print_idc ),
Constraint FK_pidc FOREIGN KEY (print_idc) REFERENCES Prints( print_id ) ON DELETE CASCADE)
TYPE = INNODB;

[anon191]

Ah I didn't realise they had to balance like that!

 

Thankyou so much for your help, all is working now

Greatly appreciated!