MySQL中的表注释长度 [英] Table comment length in MySQL

问题描述

根据MySQL手册，表格注释不得超过60个字符.我在MySQL Workbench中设计架构，该架构没有强制执行此限制，因此最终我经常编写60多个符号，这会导致SQL脚本失败.实话实说，我对表注释在我的架构内部(即未导出到实际数据库)非常满意，但是Workbench也不允许这样做.因此，我的问题是:有没有办法将MySQL中表注释的最大长度增加到255?

According to MySQL manual, table comments are limited to 60 characters. I'm designing the schema in MySQL Workbench, which does not enforce this limit, so I end up with writing more than 60 symbols quite often, and this causes the SQL script to fail. To tell the truth I would be quite happy with table comments being internal to my schema (i.e. not exported to the actual database), but Workbench doesn't allow this either. Hence my question: is there a way to increase maximum length of table comment in MySQL to 255?

推荐答案

我来自Google.此60个字符的限制已经取消了 long 时间 http://dev.mysql.com/doc/refman/5.5/en/create-table.html

I came here from Google. This 60-character limit has been defunct for a long time http://dev.mysql.com/doc/refman/5.5/en/create-table.html

COMMENT

表的注释，最长2048个字符(MySQL 5.5.3之前的60个字符).

A comment for the table, up to 2048 characters long (60 characters before MySQL 5.5.3).

这篇关于MySQL中的表注释长度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！