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

Java Users and Roles

Edward Poon
Edward Poon
9,313 Points
Posted by Edward Poon
Edward Poon
9,313 Points

Why don't we need to explicitly include the role_id for user insertion?

In the SQL statement:

insert into user (username, enabled, password) values ('user', true, 'password', 1)

Why don't we have it as:

insert into user (username, enabled, password, role_id) values ('user', true, 'password', 1)?

It would be a lot more apparent what is happening if we did it like this.

1 Answer

Alexander Nikiforov
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Alexander Nikiforov
Java Web Development Techdegree Graduate 22,175 Points
Alexander Nikiforov
.a{fill-rule:evenodd;}techdegree seal-36
Alexander Nikiforov
Java Web Development Techdegree Graduate 22,175 Points

You are absolutely right! :)

Please check the Teacher's Notes right below the video.

Chris made a mistake, but showed the proper way in Teacher's notes, and also will say about this in the next lecture.