Computer scienceFundamentalsSQL and DatabasesDBMSMySQLDB objects

Views

About insertable views

Report a typo

Can you INSERT some new records about dogs using white_dogs view?

P.S.: dogs and dogs_sorts are tables.

CREATE VIEW white_dogs AS
SELECT d.name, s.color
FROM dogs AS d
INNER JOIN dogs_sorts AS s
ON d.sort = s.sort
WHERE s.color = 'white';

Select one or more options from the list

No, because there is INNER JOIN in the view definition

No, because dogs and dogs_sorts aren't views

Yes, you can do that

No, because there is no WHERE condition in the view definition

No, because there is no GROUP BY in the view definition

___

Create a free account to access the full topic