MySQL Forums
Forum List  »  Views

Schema name added in view script, I dont want it
Posted by: Richard Jansen
Date: April 26, 2011 07:10AM

How can I remove the schema name which is placed before the table name in my view script. Every time I compile the view script, the schema name is added again. I dont want this because I want to copy the schema to another database server and schema. I use EMS SQLManager for MySQL.

The script:

select
`digitalis_ee`.`exp_members`.`pmember_id` AS `licenseId`,
`digitalis_ee`.`exp_freeform_entries`.`guidelines_id` AS `resourceId`,
`prescriptor_2_0_0`.`ee_resource`.`name` AS `name`,
`prescriptor_2_0_0`.`ee_resource`.`type` AS `type`,
date_format(from_unixtime(`digitalis_ee`.`exp_freeform_entries`.`expiredate`),'%Y-%m-%d') AS `expireDate`
from

((`digitalis_ee`.`exp_members` left join `digitalis_ee`.`exp_freeform_entries` on((`digitalis_ee`.`exp_freeform_entries`.`author_id` = `digitalis_ee`.`exp_members`.`member_id`))) left join `prescriptor_2_0_0`.`ee_resource` on((`digitalis_ee`.`exp_freeform_entries`.`guidelines_id` = `prescriptor_2_0_0`.`ee_resource`.`id`)))
where
(`digitalis_ee`.`exp_freeform_entries`.`guidelines_id` is not null)

tnx for your reply

Options: ReplyQuote


Subject
Views
Written By
Posted
Schema name added in view script, I dont want it
2375
April 26, 2011 07:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.