MySQL-如何在不破坏现有数据的情况下增加数据库中现有列的varchar大小? [英] MySQL - How to increase varchar size of an existing column in a database without breaking existing data?

问题描述

我有一列当前为varchar(100)，我想使其为10000.

I have a column that is currently varchar(100) and I want to make it 10000.

像

alter table table_name set column col_name varchar (10000);

恐怕会破坏现有数据.如果我运行此查询，可以吗?还是应该以另一种方式alter专栏?

I am afraid to corrupt the exiting data. Will I be ok if I run this query? Or should I do I alter the column another way?

谢谢！

推荐答案

我通常使用以下语句:

ALTER TABLE `table_name`
  CHANGE COLUMN `col_name` `col_name` VARCHAR(10000);

但是，我认为SET也可以工作，从来没有尝试过. :)

But, I think SET will work too, never have tried it. :)

这篇关于MySQL-如何在不破坏现有数据的情况下增加数据库中现有列的varchar大小?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！