File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Other Languages and the fly likes Migrations/MySQL problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Languages » Other Languages
Bookmark "Migrations/MySQL problem" Watch "Migrations/MySQL problem" New topic

Migrations/MySQL problem

Eric Martinez

Joined: Nov 20, 2005
Posts: 25
Hi again guys,

I have a migrations file that creates a table called order. The problem is that order is a reserved word in MySQL and it gave me a big headache trying to find that out. I read that in MySQL you are allowed to use reserved words as
identifiers as long as you put them in single quotes. I end up doing this

and when I try to scaffold using the order model I still get an error. Is there anyway to get around this without renaming the model?

BTW- The error I get tells me that I need to create a table for my model before updating scaffolding from new DB schema

I agree. Here's the link:
subject: Migrations/MySQL problem
jQuery in Action, 3rd edition