Recording yes or no in mysql

Question

Possible Duplicate:
Which MySQL Datatype to use for storing boolean values?

I need to record a yes or no, 1 or 0, it doesn't really matter. One for each day for a user. It is updated every day.

What structure should this table be?

score 2 · Answer 1 · answered May 13 '11 at 18:49

2

Have a table that called whatever you need it to be, for example users_daily with the columns

id

user_id

yes (0 = no, 1 = yes) (tinyint),

timestamp

answered May 13 '11 at 18:49

mikelbring

score 2 · Answer 2 · answered May 13 '11 at 18:52

2

create a column of type BIT for the table

answered May 13 '11 at 18:52

HaloWebMaster

2 Answers2