Question · SQL and MySQL course · Module 10: Transactions and advanced SQL

Creating a view

Which syntax creates a view in MySQL?

Answer options

  • CREATE VIEW name AS SELECT ...
  • MAKE VIEW name = SELECT ...
  • NEW VIEW name FROM SELECT ...
  • SELECT VIEW name AS ...

You can check the correct answer by solving this task in the CodeWorlds game.