MySQL Forums
Forum List  »  Views

Re: Creating Views problem in 5.6/5.7
Posted by: Kavitha K P
Date: June 22, 2017 04:12PM

CREATE VIEW `slickval` AS SELECT
`basic_slick`.`fieldval` AS `fieldval` ,
`basic_slick`.`slidesShow` AS `slidesShow` ,
`basic_slick`.`autoplay` AS `autoplay` ,
`basic_slick`.`speed` AS `speed` ,
`responsive_slick`.`tabporbkpoint` AS `tabporbkpoint` ,
`responsive_slick`.`tablanbkpoint` AS `tablanbkpoint` ,
`basic_slick`.`autoplayspeed` AS `autoplayspeed` ,
`responsive_slick`.`smalltouchpor` AS `smalltouchpor` ,
`responsive_slick`.`tabletland` AS `tabletland` ,
`responsive_slick`.`smalltouchland` AS `smalltouchland` ,
`responsive_slick`.`smalltouchporbkpoint` AS `smalltouchporbkpoint` ,
`responsive_slick`.`smalltouchbreakpoint` AS `smalltouchbreakpoint` ,
`responsive_slick`.`tabletpor` AS `tabletpor`
FROM
(
`basic_slick`
LEFT JOIN `responsive_slick` ON(
(
`basic_slick`.`entity_id` = `responsive_slick`.`entity_id`
)
)
);


basic_slick and responsive_slick are two views .

CREATE VIEW `basic_slick` AS SELECT
`field_data_field_slickclass`.`field_slickclass_value` AS `fieldval` ,
`field_data_field_slidestoshow`.`field_slidestoshow_value` AS `slidesShow` ,
`field_data_field_autoplay`.`field_autoplay_value` AS `autoplay` ,
`field_data_field_speed`.`field_speed_value` AS `speed` ,
`field_data_field_autoplayspeed`.`field_autoplayspeed_value` AS `autoplayspeed` ,
`field_data_field_slickclass`.`entity_id` AS `entity_id`
FROM
(
(
(
(
`field_data_field_slickclass`
JOIN `field_data_field_slidestoshow` ON(
(
`field_data_field_slidestoshow`.`entity_id` = `field_data_field_slickclass`.`entity_id`
)
)
)
JOIN `field_data_field_speed` ON(
(
`field_data_field_slidestoshow`.`entity_id` = `field_data_field_speed`.`entity_id`
)
)
)
JOIN `field_data_field_autoplay` ON(
(
`field_data_field_speed`.`entity_id` = `field_data_field_autoplay`.`entity_id`
)
)
)
JOIN `field_data_field_autoplayspeed` ON(
(
`field_data_field_autoplayspeed`.`entity_id` = `field_data_field_slickclass`.`entity_id`
)
)
);


CREATE VIEW `responsive_slick` AS SELECT
`field_data_field_small_touch_landscape`.`entity_id` AS `entity_id` ,
`field_data_field_tablet_portrait`.`field_tablet_portrait_value` AS `tabporbkpoint` ,
`field_data_field_tablet_landscape`.`field_tablet_landscape_value` AS `tablanbkpoint` ,
`field_data_field_small_touch_portrait`.`field_small_touch_portrait_value` AS `smalltouchporbkpoint` ,
`field_data_field_small_touch_landscape`.`field_small_touch_landscape_value` AS `smalltouchbreakpoint` ,
`field_data_field_slidestoshow_tabportrait`.`field_slidestoshow_tabportrait_value` AS `tabletpor` ,
`field_data_field_slidestoshow_tabletland`.`field_slidestoshow_tabletland_value` AS `tabletland` ,
`field_data_field_slidestoshow_smalltouchpor`.`field_slidestoshow_smalltouchpor_value` AS `smalltouchpor` ,
`field_data_field_slidestoshow_smalltouchlan`.`field_slidestoshow_smalltouchlan_value` AS `smalltouchland`
FROM
(
(
(
(
(
(
(
`field_data_field_slidestoshow_smalltouchlan`
JOIN `field_data_field_slidestoshow_smalltouchpor` ON(
(
`field_data_field_slidestoshow_smalltouchlan`.`entity_id` = `field_data_field_slidestoshow_smalltouchpor`.`entity_id`
)
)
)
JOIN `field_data_field_slidestoshow_tabletland` ON(
(
`field_data_field_slidestoshow_smalltouchpor`.`entity_id` = `field_data_field_slidestoshow_tabletland`.`entity_id`
)
)
)
JOIN `field_data_field_slidestoshow_tabportrait` ON(
(
`field_data_field_slidestoshow_tabletland`.`entity_id` = `field_data_field_slidestoshow_tabportrait`.`entity_id`
)
)
)
JOIN `field_data_field_small_touch_landscape` ON(
(
`field_data_field_slidestoshow_tabportrait`.`entity_id` = `field_data_field_small_touch_landscape`.`entity_id`
)
)
)
JOIN `field_data_field_small_touch_portrait` ON(
(
`field_data_field_small_touch_portrait`.`entity_id` = `field_data_field_small_touch_landscape`.`entity_id`
)
)
)
JOIN `field_data_field_tablet_landscape` ON(
(
`field_data_field_tablet_landscape`.`entity_id` = `field_data_field_small_touch_portrait`.`entity_id`
)
)
)
JOIN `field_data_field_tablet_portrait` ON(
(
`field_data_field_tablet_portrait`.`entity_id` = `field_data_field_tablet_landscape`.`entity_id`
)
)
);


There are no difference in the ini file.

Thanks,

Options: ReplyQuote


Subject
Views
Written By
Posted
1054
June 22, 2017 02:12PM
Re: Creating Views problem in 5.6/5.7
575
June 22, 2017 04:12PM


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.