That seems like a nice trick. I suppose the flag would just be an int and not an enum in this case.
2008/10/3 Mr. Shawn H. Corey <[EMAIL PROTECTED]>: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]