Slick - MySQL Syntax Error

Question

I'm using the Play Framework (2.3.1) together with Slick (play-slick version 0.8.0-M1) and a MySQL Database (5.5.28). One of my queries results in a MySQLSyntaxErrorException: ``` Preparing statement: select x2."id", x2."course_id", x2."trainee_id", x2."transaction_id" from "trainee_grouptraining_GroupBooking" x2 where x2."course_id" = 1 ``` The problem appears to be with the double quotation marks, since other queries work just fine and they use single quotation marks like the following: ``` Preparing statement: select x2.`id`, x2.`courseLanguage`, x2.`date`, x2.`description`, x2.`duration`, x2.`kind`, x2.`maxParticipants`, x2.`name`, x2.`courseType_id`, x2.`trainer_id` from `Course` x2 where x2.`id` = 1 ``` What can i do about this?

Accepted Answer

I guess you are importing

```
scala.slick.driver.JdbcDriver.simple._
```

You should import

```
scala.slick.driver.MySQLDriver.simple._
```

instead.

Slick - MySQL Syntax Error

Solution

Problem