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

Order in a column definition

In a column definition, e.g. nazwa VARCHAR(100), what do we write FIRST?

Answer options

  • The data type, then the column name
  • The word PRIMARY KEY, then the name
  • The column name, then its data type
  • The default value, then the name

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