语法错误或访问冲突:1059标识符名称太长 [英] Syntax error or access violation: 1059 Identifier name is too long

问题描述

创建表时收到MySQL错误:

I receive a MySQL error when I create a table:

SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'FK_SALES_FLAT_CREDITMEMO_GRID_ARCHIVE_STORE_ID_CORE_STORE_STORE_ID' is too long

如何增加默认标识符名称的大小，否则如何解决?

How can the default Identifier name size be increased or how can I solve this otherwise?

推荐答案

请查看 http://dev.mysql.com/doc/refman/5.5/zh-CN/identifiers.html -标识符的长度限制为64个字符.

Please take a look at http://dev.mysql.com/doc/refman/5.5/en/identifiers.html - you are limited to 64 chars to an identifier.

这篇关于语法错误或访问冲突:1059标识符名称太长的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！