Removing NOT NULL restriction from column in MySQL

mysql null alter
Aufwind picture Aufwind · Apr 18, 2011 · Viewed 19.9k times · Source

How can I alter a column whose restricted to NOT NULL to accept NULL values?

Answer

regality picture regality · Apr 18, 2011

just modify it and put in the old type and leave off the not null

alter table table_name modify column foo int;

Related questions

MySQL: selecting rows where a column is null

I'm having a problem where when I try to select the rows that have a NULL for a certain column, it returns an empty set. However, when I look at the table in phpMyAdmin, it says null for most of …

Read More
MySQL and PHP - insert NULL rather than empty string

I have a MySQL statement that inserts some variables into the database. I recently added 2 fields which are optional ($intLat, $intLng). Right now, if these values are not entered I pass along an empty string as a value. How do …

Read More
Checking for an empty field with MySQL

I've wrote a query to check for users with certain criteria, one being they have an email address. Our site will allow a user to have or not have an email address. $aUsers=$this->readToArray(' SELECT `userID` FROM `…

Read More