Mysql Create Table error

Question

Error SQL query:

CREATE TABLE Contacts(

Contact_ID INT NOT NULL ,
User VARCHAR NOT NULL ,
User_ID INT( 15 ) ,
PRIMARY KEY ( Contact_ID ) ,
FOREIGN KEY ( User_ID ) REFERENCES Users( User_ID )
)

MySQL said:

#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 'NOT NULL,
User_ID int(15),
PRIMARY KEY (Contact_ID),
FOREIGN KEY (User_ID) RE' at line 4

Erik Ekman · Accepted Answer · 2012-03-12 20:43:57Z

4

You need to supply the length of the VARCHAR field, like VARCHAR(64).

answered Mar 12, 2012 at 20:43

Erik Ekman

2,08612 silver badges13 bronze badges

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

6 Comments

Arham Ali Qureshi Over a year ago

Yes it worked thank but why ? look at this link here please w3schools.com/sql/sql_foreignkey.asp

DanRedux Over a year ago

The 64 means 64 characters can be stored in that field, you can freely change it.

octern Over a year ago

Just what Erik said. Varchar fields require an explicit length, which becomes the maximum number of characters you can put in the field.

Erik Ekman Over a year ago

That link has nothing to do with VARCHAR.

Erik Ekman Over a year ago

The length of INT is optional since it is only about how many digits to display and not about storage length. VARCHAR is different though.

|

Collectives™ on Stack Overflow

Mysql Create Table error

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related