HomeMySQLMySQL Error 1005 – ER_CANT_CREATE_TABLE

MySQL Error 1005 – ER_CANT_CREATE_TABLE

MySQL Error Message

Can’t create table ‘%s’ (errno: %d – %s)

Reason for the Error

InnoDB reports this error when a table cannot
be created. If the error message refers to error 150, table
creation failed because a
foreign key
constraint was not correctly formed. If the error message
refers to error −1, table creation probably failed because
the table includes a column name that matched the name of an
internal InnoDB table.

Share:

Leave a Reply

You May Also Like

MySQL Error Message Ignored the innodb-redo-log-capacity option in the Innodb read-only mode. Server is using active redo log files. Reason...
  • MySQL
  • November 17, 2022
MySQL Error Message This member is configured with a group_replication_paxos_single_leader option value of 1 and it is trying to join...
  • MySQL
  • November 17, 2022
MySQL Error Message Record has both instant and version bit set. Reason for the Error ER_CHECK_TABLE_INSTANT_VERSION_BIT_SET was added in 8.0.32.
  • MySQL
  • November 17, 2022