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

Posted by Mostafa Alhosain
Mostafa Alhosain
7,305 Points

Hey, I have a question regarding databases especially MySQL.

In the SQL Playground whenever I try to use the MySQL code in the teacher's notes I keep getting errors that those functions like CONCAT() and NOW() don't exist. When I use functions of say PostgreSQL it works normally. So what's wrong?

1 Answer

Steven Parker
Steven Parker
231,269 Points
Steven Parker
Steven Parker
231,269 Points

The playground uses SQLite. Functions available in other databases will not work unless they happen to also be implemented in SQLite.

The Teacher's Notes are for students working in local databases instead of the playground.

Mostafa Alhosain
Mostafa Alhosain
7,305 Points

Ohh Ok Thanks A lot, it was starting to get frustrating hahaha.