Vidyalelo
MySQL · Q592

MySQL

Programming · MySQL · question 592

Q592

What is the default value of column?

A.
NULL
Answer
B.
0
C.
-1
D.
Undefined

Answer: Option A

Solution

Answer: Option A
Solution:
In MySQL, when you create a new table and define a column, it often needs a starting value. This is called the default value.

This question asks about the default value if you don't explicitly specify one for your column.

The answer is Option A: NULL.

Here's why:
* NULL means "no value" or "unknown". It's the most common default in MySQL.
* 0 is a specific value, not the default.
* -1 is also a specific value, not the default.
* Undefined is not a valid default value in MySQL.

Think of it like this: If you create a column for "age" and don't provide a default, MySQL will set the age to NULL for new rows until you provide a value.

Key Takeaway: When you create a column in MySQL and don't specify a default value, the column will automatically have a NULL value.