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 <[EMAIL PROTECTED]>: > 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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
