I have created a view which is showing the data from multiple tables . now I want to perform Data manipulation operations on view . How can I achieve this ?
This is my view
CREATE
ALGORITHM = UNDEFINED
DEFINER = `forge`@`%`
SQL SECURITY DEFINER
VIEW `contact_view` AS
SELECT
`c`.`id` AS `id`,
`c`.`fname` AS `fname`,
`c`.`mname` AS `mname`,
`c`.`lname` AS `lname`,
CONCAT(`c`.`fname`, ' ', `c`.`lname`) AS `fullname`,
`c`.`gender` AS `gender`,
`c`.`dob` AS `dob`,
`c`.`points` AS `points`,
`c`.`stars` AS `star`,
`c`.`inst_id` AS `inst_id`,
`c`.`ingr_id` AS `ingr_id`,
`c`.`fami_id` AS `fami_id`,
`c`.`sour_id` AS `sour_id`,
`c`.`image` AS `img`,
`c`.`address` AS `address`,
`c`.`email` AS `email`,
`c`.`doc` AS `doc`,
`cl`.`value` AS `mobile`,
`p`.`district` AS `district`,
`p`.`pincode` AS `pincode`
FROM
(((`contact` `c`
JOIN `communication_link` `cl`)
JOIN `contact_communication` `cc`)
JOIN `pincode_db` `p`)
WHERE
((`cl`.`cont_id` = `c`.`id`)
AND (`cl`.`coco_id` = 1)
AND (`c`.`pinc_id` = `p`.`id`))
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire