A

Admin • 833.24K Points
Coach

Q. Which SQL statement is used to create a view in MySQL?

  • (A) CREATE TABLE view_name AS SELECT ...
  • (B) CREATE VIEW view_name AS SELECT ...
  • (C) MAKE VIEW view_name AS SELECT ...
  • (D) NEW VIEW view_name AS SELECT ...

Explanation by: Admin

The correct syntax to create a view is CREATE VIEW view_name AS SELECT statement.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.