MySQL Crash Course by Rick Silva

Author:Rick Silva
Language: eng
Format: mobi
ISBN: 9781718503014
Published: 2023-01-10T00:00:00+00:00

Now, the next time you want to get a list of companies with a count of complaints, you can simply type select * from v_complaint instead of rewriting the entire query.

Next, you’ll create another view that hides the owner information. You’ll name the view v_complaint_public, and you’ll let all users of your database access the view. This view will show the company name and number of complaints, but not the owner’s name or phone number:

create view v_complaint_public as

select a.company_name,

count(*)

from company a

join complaint b

on a.company_id = b.company_id

group by a.company_name;

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.