MySQL
keyboard_arrow_down 295 guides
chevron_leftArticles
check_circle
Mark as learned thumb_up
0
thumb_down
0
chat_bubble_outline
0
Comment auto_stories Bi-column layout
settings
Default column values in MySQL
schedule Aug 12, 2023
Last updated local_offer
Tags MySQL
tocTable of Contents
expand_more Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!
Start your free 7-days trial now!
By default, MySQL will not set default values for your column entries. Refer here for how to add a default value for a column in MySQL.
Example
To create a simple table with two columns name and age:
CREATE TABLE students ( name VARCHAR(30), age INT);
To then insert a record into the above table:
INSERT INTO students (name)VALUES ('bob');
Note that we have not included any value for the age. Nonetheless, the code is perfectly valid. Now, let’s see how the table looks like:
SELECT * FROM students;
+------+------+| name | age | +------+------+| bob | NULL | +------+------+
Since we have not included the value for age, MySQL inserts a NULL value. For those who are familiar with programming languages like Java, you may have expected the age to be set to 0 since we have set the data type for the age column to be INT. However, this is clearly not the case for MySQL.
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!
