From: Alex K (spaceoutletgmail.com)
Date: Fri Oct 03 2008 - 11:55:58 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

2) is probably cleaner but a hassle as well because one needs to make
sure all user_ids are also in this new table.

2008/10/3 Alex K <spaceoutletgmail.com>:
> Hello,
>
> I have a table of a 1 million users. I want to add a flag called
> delete if a user wants to delete his account. Note that this situation
> does not happen a lot.
>
> 1) Should I alter my users table and add a delete flag to the users table.
>>> it's easy to update however it uses a lot of unnecessary space.
>
> 2) Should I create a new table user_id, flag already prefilled with
> all user_ids.
>
> 3) Should I create a new table called deleted_users that has a user_id
> if this user wants to be deleted.
>>> it's hassle to update but takes into consideration the spareness of the data.
>
> Thank you,
>
> Alex
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]