Use NOT NULL if required

update fields with random sentence

First of all think whether you require a NULL field or not.
If having an empty string value can make any sense then use it otherwise use NULL value for a specific reason.

So, Use NOT NULL if required.

NULL columns require additional space in the row and add complexity to your statement. Avoid it for a no reason. In MyISAM table for each column it takes one bit extra rounded up to the nearest byte.

For any types of queries, you can contact us on info@namasteui.com.

You may like:  MySQL UPDATE Statement

Leave a Reply

Your email address will not be published. Required fields are marked *