MySQL :: MySQL 5.6 Reference Manual :: 13.2.5 INSERT Syntax

You can provide a comma-separated list of column names following the table name. In this case, a value for each named column must be provided by the VALUES list or the SELECT statement. If you do not specify a list of column names ...

dev.mysql.com