Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Cannot specify a column width on data type int

I'm new here. I'm attempting to create a table in ms sql database using mylittleadmin. I've read and reread the code and can't seem to figure out why I am getting the following error:

"Msg 2716, Level 16, State 1, Line number 1 Column, parameter, or variable #8: Cannot specify a column width on data type int."

The code is as follows...

CREATE TABLE surrogate(
Last_Name1 VarChar(255),
First_Name1 VarChar(255),
ID int,
Street_Address int,
City VarChar(255),
State_or_Province VarChar(255),
Country VarChar(255),
Zip_Code int(255),
Home_Phone int,
Mobile_Phone int,
Work_Phone int,
Email VarChar(255),
Last_Name2 VarChar(255),
First_Name2 VarChar(255),
ID int,
Street_Address2 int,
City2 VarChar(255),
State_or_Province2 VarChar(255),
Country2 VarChar(255),
Zip_Code2 int,
Home_Phone2 int,
Mobile_Phone2 int,
Work_Phone2 int,
Email2 VarChar(255),
Last_Name3 VarChar(255), 
First_Name3 VarChar(255),
ID int,
Street_Address3 int,
City3 VarChar(255),
State_or_Province3 VarChar(255),
Country3 VarChar (255),
Zip_Code3 int,
Home_Phone3 int,
Mobile_Phone3 int,
Work_Phone3 int,
Email3 VarChar(255))
like image 456
Toussaint Avatar asked Apr 22 '14 15:04

Toussaint


1 Answers

Its just a typo mistake. Guess you haven't seen it yet. This is the problem:

Zip_Code int(255),

Change it to

Zip_Code int,

Hope this helps!!!

like image 123
Satwik Nadkarny Avatar answered Oct 16 '22 08:10

Satwik Nadkarny