如何修改MySQL栏以允许NULL? [英] How do I modify a MySQL column to allow NULL?

问题描述

MySQL 5.0.45

MySQL 5.0.45

更改表以允许列为null的语法是什么?

What is the syntax to alter a table to allow a column to be null, alternately what's wrong with this:

ALTER mytable MODIFY mycolumn varchar(255) null;

我将手册解释为仅运行上面的内容，它将重新创建该列，这次允许为空.服务器告诉我我有语法错误.我只是看不到他们.

I interpreted the manual as just run the above and it would recreate the column, this time allowing null. The server is telling me I have syntactical errors. I just don't see them.

推荐答案

您需要以下内容:

ALTER TABLE mytable MODIFY mycolumn VARCHAR(255);

默认情况下，列为空.只要该列未声明为UNIQUE或NOT NULL，就不会有任何问题.

Columns are nullable by default. As long as the column is not declared UNIQUE or NOT NULL, there shouldn't be any problems.

这篇关于如何修改MySQL栏以允许NULL?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！