mysql error #1064 while creating table

Question

CREATE TABLE Exhibitor_Info
(Ex_id int AUTO_INCREMENT,User_id int,Category varchar(150),Description varchar(400), PRIMARY KEY(Ex_id),FOREIGN KEY(User_id));

while executing this sql I got the following error:

#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 ')' at line 2

Can anyone help me to fix the problem

thanks

a foreign key has to reference something..

amdixon
– amdixon

2015-08-20 11:32:24 +00:00
Commented Aug 20, 2015 at 11:32 — amdixon
– amdixon, Commented Aug 20, 2015 at 11:32

Aman Kaur · Accepted Answer · 2015-08-20 11:43:07Z

1

Add reference to foreign key by replacing

FOREIGN KEY(User_id)

with

foreign key(user_id) references referred_table(referred_col)

answered Aug 20, 2015 at 11:43

Aman Kaur

3211 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sagar Panda · Accepted Answer · 2015-08-20 12:08:35Z

0

You have to add the reference to a foreign key

CREATE TABLE Exhibitor_Info (Ex_id int AUTO_INCREMENT,User_id int,Category varchar(150),Description varchar(400), PRIMARY KEY(Ex_id),FOREIGN KEY(User_id) REFERENCES referred_parent_table(referred_col) ON DELETE CASCADE);

You can have a good example here

answered Aug 20, 2015 at 12:08

Sagar Panda

5613 silver badges17 bronze badges

2 Comments

Sagar Panda Over a year ago

You can also set the ON DELETE and ON UPDATE as per your requirement.

Sagar Panda Over a year ago

If my answer as helped you in any ways then you can accept my answer

Collectives™ on Stack Overflow

mysql error #1064 while creating table

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related