MySQL
keyboard_arrow_down 295 guides
chevron_leftColumn Cookbooks
check_circle
Mark as learned thumb_up
0
thumb_down
0
chat_bubble_outline
0
auto_stories new
settings
Modifying a column to allow NULL in MySQL
schedule Mar 5, 2023
Last updated local_offer
Tags MySQL
tocTable of Contents
expand_more Check out the interactive map of data science
By default columns in MySQL can take on NULL values unless you have explicitly specified the column as NOT NULL or UNIQUE.
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
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!
