在MySql中增加varchar长度的可能后果? [英] Possible consequences of increasing varchar length in MySql?

问题描述

我正在使用一个旧表，其中有一个varchar(40)字段.我希望可以在该字段中插入更多字符，所以我想增加它的长度.
在增加长度之前，我是否应该考虑可能的负面后果?

I'm using an old table, which has a varchar(40) field in it. I want it to be possible to insert more characters in that field, so I want to increase the length of it.
Are there possible negative consequences I should think of before increasing the length?

推荐答案

增加应该通常不会引起问题，是减少会导致问题.

Increasing should typically not cause issues, it is the decreasing that can cause problems.

这篇关于在MySql中增加varchar长度的可能后果?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！