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!
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
Andy McDonaldPython Development Techdegree Graduate 13,799 Points
Expecting an extra value when not defining columns first
I can't pass the exercise without defining the columns. For example:
INSERT INTO users (null, "king", "password", "dave", "olsen") does not work. I can only pass if I make the statement as follows: INSERT INTO users (username, password, first_name, last_name) VALUES ("king", "password", "dave", "olsen")
Steven Parker224,936 Points
The second example is the correct syntax.
The first example (using the compact form) is missing the VALUES keyword between the table name and the data.