MySQL

295 guides

keyboard_arrow_down

Other math topics

Dagster

Pandas

NumPy

Matplotlib

PySpark

MySQL

chevron_leftColumn Cookbooks

Modifying a column to allow NULL Specifying position of a new column Temporarily renaming a column Adding a default column value Changing column data type Renaming a column Adding a new column to a table Removing a column from a table Resetting AUTO_INCREMENT

check_circle

Mark as learned

thumb_up

thumb_down

chat_bubble_outline

Comment

auto_stories Bi-column layout

settings

Modifying a column to allow NULL in MySQL

schedule Aug 10, 2023

Last updated

local_offer

MySQL

Example

Assume we have a VARCHAR column test_column within table test_table that is currently explicitly set to not accept NULL values.

To modify test_column to be VARCHAR(10) which can take NULL values:


        
        
            
                
                
                    ALTER TABLE test_table 
MODIFY test_column VARCHAR(10);

Although we used a VARCHAR column here, the same logic applies to any other data type column.

Published by Arthur Yanagisawa

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!