Server Error Message Reference -1060

Error number: 1046; Symbol: ER_NO_DB_ERROR; SQLSTATE: 3D000

Message: No database selected

Error number: 1047; Symbol: ER_UNKNOWN_COM_ERROR; SQLSTATE: 08S01

Message: Unknown command

Error number: 1048; Symbol: ER_BAD_NULL_ERROR; SQLSTATE: 23000

Message: Column '%s' cannot be null

Error number: 1049; Symbol: ER_BAD_DB_ERROR; SQLSTATE: 42000

Message: Unknown database '%s'

Error number: 1050; Symbol: ER_TABLE_EXISTS_ERROR; SQLSTATE: 42S01

Message: Table '%s' already exists

Error number: 1051; Symbol: ER_BAD_TABLE_ERROR; SQLSTATE: 42S02

Message: Unknown table '%s'

Error number: 1052; Symbol: ER_NON_UNIQ_ERROR; SQLSTATE: 23000

Message: Column '%s' in %s is ambiguous

%s = column name
%s = location of column (for example, "field list")

Likely cause: A column appears in a query without appropriate qualification, such as in a select list or ON clause.

Examples:

mysql> SELECT i FROM t INNER JOIN t AS t2;
ERROR 1052 (23000): Column 'i' in field list is ambiguous

mysql> SELECT * FROM t LEFT JOIN t AS t2 ON i = i;
ERROR 1052 (23000): Column 'i' in on clause is ambiguous

Resolution:

• Qualify the column with the appropriate table name:

  mysql> SELECT t2.i FROM t INNER JOIN t AS t2;

• Modify the query to avoid the need for qualification:

  mysql> SELECT * FROM t LEFT JOIN t AS t2 USING (i);

Error number: 1053; Symbol: ER_SERVER_SHUTDOWN; SQLSTATE: 08S01

Message: Server shutdown in progress

Error number: 1054; Symbol: ER_BAD_FIELD_ERROR; SQLSTATE: 42S22

Message: Unknown column '%s' in '%s'

Error number: 1055; Symbol: ER_WRONG_FIELD_WITH_GROUP; SQLSTATE: 42000

Message: '%s' isn't in GROUP BY

Error number: 1056; Symbol: ER_WRONG_GROUP_FIELD; SQLSTATE: 42000

Message: Can't group on '%s'

Error number: 1057; Symbol: ER_WRONG_SUM_SELECT; SQLSTATE: 42000

Message: Statement has sum functions and columns in same statement

Error number: 1058; Symbol: ER_WRONG_VALUE_COUNT; SQLSTATE: 21S01

Message: Column count doesn't match value count

Error number: 1059; Symbol: ER_TOO_LONG_IDENT; SQLSTATE: 42000

Message: Identifier name '%s' is too long

Error number: 1060; Symbol: ER_DUP_FIELDNAME; SQLSTATE: 42S21

Message: Duplicate column name '%s'