Question: what is the difference between null and empty in mysql?
Answer: NULL is an absence of a value. An empty string is a value, but is just empty. ... NULL isn't allocated any memory, the string with NULL value is just a pointer which is pointing to nowhere in memory. however, Empty IS allocated to a memory location, although the value stored in the memory is "" .