CODEWITHSUNDEEP
phpmysqldatabase
CyberJunkie
CyberJunkie

Reputation: 22674

mysql default value?

In my database, is it standard to leave most fields with default value "none"? For example a user id, a post title, category, or tags.

Upvotes: 0

Views: 2096

Answers (2)

Sarfraz
Sarfraz

Reputation: 382616

For required fields such as username or password, you should set NOT NULL. For other optional fields you can set it to NULL. For numbers, it is almost always a good idea to set default value to zero 0 .

Upvotes: 1

Michael
Michael

Reputation: 784

I'll answer your question as I best understand it.

For User_id, it is common to set its default value to auto_increment. SQL will automatically fill this in when you create a new record.

Text fields will default to null, although when you create the table you can set a DEFAULT such as ' ', 'cat' or anything else you like.

Upvotes: 1

Related Questions