DEV Community

Discussion on: Understanding the basics of Ruby on Rails: SQL Databases and how they work

dmfay profile image
Dian Fay • Edited

You don't mention different flavors of relational database, but it looks like you're using MySQL; the standard reserves double quotes for identifiers (eg table or column names) and as far as I know only MySQL allows them for strings. If anyone's trying to run the SQL statements from the article on Postgres or another RDBMS, you'll need to change the double quotes (") to single (').