T
T
Torento203452021-06-18 18:23:37
MySQL
Torento20345, 2021-06-18 18:23:37

Why does value="" write empty and not NULL?

As I understand it, in SQL
NULL is emptiness and it is better to write it than an empty string.
Or does it make any difference whether I will check the column for NULL or for emptiness?
It's just that there are problems with writing NULL, but writing emptiness is not difficult.

And if NULL is better, then how to write it through value?
value="NULL" - writes "NULL" as a string, not as NULL

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Akina, 2021-06-18
@Torento20345

NULL and an empty string are two completely different things (the exception is Oracle). NULL is the absence of any, including empty, value.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question