Multiple Schemas
Posted: Mon Aug 16, 2010 8:19 pm
Hello
I have just started using nuBuilder and I think its a great tool!
I would like to have nuBuilder access multiple mysql schemas located in the same mysql database/server.
Ex: Setup nuBuilder in schema 1 and manage my tables located in schema 1 and schema 2 using nuBuilder.
Is there any way to prefix the table names to use the `schema`.`table` format.
I have tried setting FORM field "Table" and "SQL 'to use the follow but both return an SQL error:
Thanks in advance
I have just started using nuBuilder and I think its a great tool!
I would like to have nuBuilder access multiple mysql schemas located in the same mysql database/server.
Ex: Setup nuBuilder in schema 1 and manage my tables located in schema 1 and schema 2 using nuBuilder.
Is there any way to prefix the table names to use the `schema`.`table` format.
I have tried setting FORM field "Table" and "SQL 'to use the follow but both return an SQL error:
Could not execute : --
SELECT merchant_id, order_id FROM smaw_prod.Order_Detail LIMIT 0, 27
Could not execute : --
SELECT merchant_id, order_id FROM `smaw_prod`.`Order_Detail` LIMIT 0, 27
Code: Select all
Setup / Forms / General Tab Fields:
TABLE SQL
schema1.table SELECT * FROM schema1.table
`schema1`.`table` SELECT * FROM `schema1`.`table`