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

Development Tools Database Foundations Securing and Maintaining a MySQL Database Indexing Columns in MySQL

Don Shipley
Don Shipley
19,488 Points
Posted by Don Shipley
Don Shipley
19,488 Points

Challenge task 2 of 2 Use the EXPLAIN keyword to explain a where query where you see if the 'first_name' equals 'Pasan'

I do not understand why it does not pass. From the video, EXPLAIN SELECT * FROM users WHERE last_name= "Chalkley"; my answer EXPLAIN SELECT * FROM users WHERE first_name= "Pasan"; Also tried EXPLAIN SELECT first_name FROM users WHERE first_name= "Pasan";

Don Shipley
Don Shipley
19,488 Points
Don Shipley
Don Shipley
19,488 Points

Worked this time not sure why it did not pass the first time. Thank you for reading..

1 Answer

Lei Zhou
Lei Zhou
2,445 Points
Lei Zhou
Lei Zhou
2,445 Points

i got the same problem, i believe it was a bug in the system.