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 cas
>-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 tric
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
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 happe
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
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 fla
[EMAIL 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) Sho
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 fla
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 sit
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 unnecess
10 matches
Mail list logo
