If you want to choose the first one, then the flag' data type must be
enum.For int fill the disk with 4 byte and enum just 1 byte.
On Sat, Oct 4, 2008 at 2:15 AM, Alex K [EMAIL PROTECTED] wrote:
That seems like a nice trick. I suppose the flag would just be an int
and not an enum in this case.
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
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
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
PROTECTED]
To: mysql@lists.mysql.com
Subject: simple design choice
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
I would do #3.
On 10/3/08, 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
Hi,
Personally I would do #3 as well. Have an exact copy (structurally) of
your original table, when the record is deleted then move the account's
details to your deleted_users table so it doesn't appear in users but
you still have all the details.
Not sure if it's possible in MySQL but in
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.
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
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Alex K
Sent: Friday, October 03, 2008 2:15 PM
To: Mr. Shawn H. Corey
Cc: Rob Wultsch; mysql@lists.mysql.com
Subject: Re: simple design choice
That seems like a nice trick. I suppose the flag would just
10 matches
Mail list logo