On Thu, Mar 22, 2012 at 1:29 PM, Peter of the Norse <rahmcoff+...@radio1190.org> wrote: > In our legacy system at work, we're using different different databases on > the same sever at the same time. It looks like ”Select * From client_a.user > Inner Join common.table On…”. I know that ticket 6148 is still a long way > from being included, but I was wondering if there is a workaround. I’ve seen > that in PostgreSQL you can use db_table = 'schema\".\"tablename' > Does something similar work in MySQL? Has anyone tried it? > > Peter of the Norse > rahmc...@radio1190.org
Yes, I've seen a similar sort of construct in use with mysql. This is what we use with mysql: "`%s`.`%s`" % (schema, table_name) Works fine as far as I know (I don't actually work on the project using it, just aware of the hack!) Cheers Tom -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
