Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases

Matthew Francis
Matthew Francis
6,967 Points
Posted by Matthew Francis
Matthew Francis
6,967 Points

SQL - Why must the primary key be an INTEGER instead of an INT?

If you set the primary key as an INT, it will not auto-generate the numbers when you insert the data. Eg:

CREATE TABLE contacts(
id INT PRIMARY KEY,
firstname STRING,
lastname STRING,
email STRING,
phone INT(10))

INSERT INTO CONTACTS (firstname , lastname, email, phone)
VALUES('Chris', 'Ramacciotti' , 'rama@teamtreehouse.com', 7735554535),
      ('James', 'Gosling' , 'james@java.com', 555557788)

So why must it be an INTEGER for it to auto-generate the numbers?

1 Answer