I came across a reserved word list for mysql: http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html But it's not complete - the table name 'log' causes an error, but is not in the list.
On Jun 19, 11:03 am, Richard <richar...@gmail.com> wrote: > hi, > > I like to develop my web2py apps with sqlite and then migrate to mysql > or postgres later. I often then find that some of the table or field > names are reserved in the new database, which requires lots of > renames. > > Does anyone have a strategy for dealing with this? > Does there perhaps exist a list of words that are reserved in at least > one database? If so, perhaps this could be somehow incorporated into > web2py to make switching between databases more seamless. > > Richard --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---