The moose likes Other Languages and the fly likes Migrations/MySQL problem Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Other Languages » Other Languages
Reply Bookmark "Migrations/MySQL problem" Watch "Migrations/MySQL problem" New topic
Author

Migrations/MySQL problem

Eric Martinez
Greenhorn

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

Thanks!
 
 
subject: Migrations/MySQL problem
 
developer file tools

cast iron skillet 49er

more from paul wheaton's glorious empire of web junk: cast iron skillet diatomaceous earth rocket mass heater sepp holzer raised garden beds raising chickens lawn care CFL flea control missoula heat permaculture