Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Development Tools

Keys and Auto-Incrementing - missing id 2?

!(http://imgur.com/KTqnUiW "This screenshot") from about 6:03 on the video shows the list of auto-incremented id numbers from the genres table. However, there is no 2 - it goes 1,3,4. Curious to know if this is a result of the failed attempt to add another 'sci fi', and whether mySQL assigns this failed attempt an auto-incremented id number anyway?

1 Answer

It could also be from deleting a record before showing it on the video.