mysql default value?

Question

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.

Sarfraz · Accepted Answer · 2011-01-20 18:20:31Z

1

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 .

answered Jan 20, 2011 at 18:20

Sarfraz

384k81 gold badges561 silver badges613 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

CyberJunkie Over a year ago

Thanks!! By NOT NULL do you mean just set the default to none and null to no?

Sarfraz Over a year ago

@CyberJunkie: yeah you can interpret that way :)

Michael · Accepted Answer · 2011-01-20 18:19:59Z

1

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.

answered Jan 20, 2011 at 18:19

Michael

7847 silver badges26 bronze badges

Collectives™ on Stack Overflow

mysql default value?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related