Question · SQL and MySQL course · Module 4: Creating tables (DDL)

CREATE TABLE syntax

What do we put inside the parentheses in a CREATE TABLE statement?

Answer options

  • The row values we want to insert right away
  • The database name and the administrator password
  • A list of other tables we are joining with
  • A list of columns with their types and constraints, separated by commas

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