如何修改mysql表中列的大小?(How can I modify the size of column in a mysql table?)
我创建了一个表,意外地将varchar长度设置为300而不是65353 。 我该如何解决?
一个例子将不胜感激。
I have created a table and accidentally put varchar length as 300 instead of 65353. How can I fix that?
An example would be appreciated.
最满意答案
你试了吗
ALTER TABLE <table_name> MODIFY <col_name> VARCHAR(65353);这将将col_name的类型更改为VARCHAR(65353)
Have you tried this?
ALTER TABLE <table_name> MODIFY <col_name> VARCHAR(65353);This will change the col_name's type to VARCHAR(65353)
更多推荐
发布评论