MySQL Interview Question: Store NULL or a Default Value in Nullable Columns?

The article examines whether a nullable MySQL column should store NULL or a business default, detailing InnoDB row formats, storage overhead, record headers, hidden columns, and the trade‑offs of NOT NULL versus NULL definitions.

Database designInnoDBNULL

0 likes · 7 min read

MySQL Interview Question: Store NULL or a Default Value in Nullable Columns?

dbaplus Community

Feb 17, 2024 · Databases

Why MySQL Shouldn’t Use NULL as a Default Column Value – Myths Debunked

This article explains why defining columns with a default NULL in MySQL is misleading, demonstrates how NULL interacts with indexes, operators, aggregate functions, and sorting, and provides practical examples and recommendations to avoid performance and correctness issues.

NULLSQLdefault value

0 likes · 13 min read

Why MySQL Shouldn’t Use NULL as a Default Column Value – Myths Debunked

Aikesheng Open Source Community

Oct 9, 2022 · Databases

Understanding MySQL Timestamp Default Values and Zero‑Date Handling

This article explains how MySQL determines default values for TIMESTAMP columns, the effect of the explicit_defaults_for_timestamp parameter, when zero‑date values are permitted via sql_mode, and demonstrates the behavior through four test scenarios with corresponding SQL statements and results.

SQL Modedefault valueexplicit_defaults_for_timestamp

0 likes · 5 min read

Understanding MySQL Timestamp Default Values and Zero‑Date Handling