selecting an option for auditing purposes
I'm designing a table to audit language (currently there are 15) selection
of users on my website. I have two table style and coding to with them but
I need your expertises to select one over another so please tell me which
is better. Open for other options if you have any.
Thanks
OPTION 1) New record gets inserted into table after user's language
selection.
TABLE
language - varchar(20) - Not Null
CODE
insert into table (language) values ('english');
OPTION 2) Value of relevant language column gets increased by 1 after
user's language selection.
TABLE
language_x - int(11) - Unsigned
language_y - int(11) - Unsigned
language_z - int(11) - Unsigned
...
...
CODE
update table SET language_x = language_x + 1;
No comments:
Post a Comment