sql-null – Tarik Billa

MySQL NULL or NOT NULL That is The Question?

May 20, 2023 by Tarik

NULL means you do not have to provide a value for the field… NOT NULL means you must provide a value for the fields. For example, if you are building a table of registered users for a system, you might want to make sure the user-id is always populated with a value (i.e. NOT NULL), … Read more

MySQL, better to insert NULL or empty string?

October 8, 2022 by Tarik

By using NULL you can distinguish between “put no data” and “put empty data”. Some more differences: A LENGTH of NULL is NULL, a LENGTH of an empty string is 0. NULLs are sorted before the empty strings. COUNT(message) will count empty strings but not NULLs You can search for an empty string using a … Read more