Question

What is the valid way to create a database view in MySQL?

a) CREATE VIEW my_view AS SELECT * FROM my_table;
b) ADD VIEW my_view TO my_database;
c) VIEW my_view CREATE SELECT * FROM my_table;
d) CREATE DATABASE my_view AS VIEW my_table;

Answer 1

The valid way to create a database view in MySQL is using the CREATE VIEW statement.

Step-by-step explanation:

The valid way to create a database view in MySQL is option a) CREATE VIEW my_view AS SELECT * FROM my_table;