CODEWITHSUNDEEP
mysql
user646645
user646645

Reputation: 53

how i can set default value in mysql field to be NULL

hello all i have problem with mysql...i have field user can save value in it or leave it empty so should i set default value for this field NULL? isnt it...ok how i do it?

Upvotes: 0

Views: 752

Answers (2)

Matteo Riva
Matteo Riva

Reputation: 25060

There is no need for a field to be NULL, yuo can just enter an empty value. This is often better as NULL means "no information present" not "field empty". A user might intentionally leave a field empty because he has nothing to fill it with (e.g. "personal website") but this IS an information, while NULL means "we don't know".

Upvotes: 0

Lea Verou
Lea Verou

Reputation: 23907

That is the default value in most cases. Just don't specify a default and of course don't specify NOT NULL for that field when defining the table schema.

Upvotes: 1

Related Questions