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!