check_circleMark as learned
Modifying a column to allow NULL in MySQL
schedule Mar 5, 2023Last updated
tocTable of Contentsexpand_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
Assume we have a
test_column within table
test_table that is currently explicitly set to not accept
test_column to be
VARCHAR(10) which can take
ALTER TABLE test_tableMODIFY 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?
Ask a question or leave a feedback...
Enjoy our search
Hit / to insta-search docs and recipes!