On Fri, 2008-10-03 at 09:58 -0700, Rob Wultsch wrote: > On Fri, Oct 3, 2008 at 9:49 AM, Alex K <[EMAIL PROTECTED]> wrote: > > 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 > > #1 Define uses a lot of unnecessary space. I would imagine it would > add not much more than 1 MB to the size of db, depending on column > choice. A decent choice I think. > > #2 Yuck. > > #3 A compact and clean solution. >
If you're going to do #1, make the new column "status", with two states: active and deleted. In the future you can add more states without re-doing your tables again. -- Just my 0.00000002 million dollars worth, Shawn Linux is obsolete. -- Andrew Tanenbaum -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
