Has anyone done this? I have a database app I'm moving over to mySQL in order to use Castor JDO libraries (Java XML to DB mapping). Problem is Castor JDO doesn't support Access. In my code I access queries stored in Access just as I would a table. I haven't figured out if a stored query is possible in mySQL, or if so, how to implement it.
My current workaround will be to create a table as "Create table new_table as (Select ..[query stuff will go here]). I think this will work but I will have to modify the SQL code in my app, which I would rather not do.