Hi.
On Thu, Jul 19, 2001 at 07:24:17PM +0100, [EMAIL PROTECTED] wrote:
>
> I have been searching through the manual and the list archives for the last
> few days regarding a problem I have with the SET column type.
>
[...]
> For example
>
> UPDATE users SET user_flags = CONCAT(user_flags,'pass
On 19-Jul-2001 Nick Brandon wrote:
> Hi
>
> I have been searching through the manual and the list archives for the last
> few days regarding a problem I have with the SET column type.
>
> I'm creating an app that uses a SET column as 'flags'. Different parts
> within the application will check
On 19-Jul-2001 Nick Brandon wrote:
> Hi
>
> I have been searching through the manual and the list archives for the last
> few days regarding a problem I have with the SET column type.
>
> I'm creating an app that uses a SET column as 'flags'. Different parts
> within the application will check
Dear Nick,
I dislike SET and ENUM as they are not SQL standard (tell me if I am
wrong). They may be fast because of the bitwise storage of data. But
both column types mangle DDL with DML, and that's where problems arise,
like yours.
Suggestion: Better go the straight way, i. e. put those flags i
I would take another approach.
table 1 has only user_id
table 2 has flag values and key user_id
So you just insert rows or delete them in table 2. That's it.
Did I understand your problem?
Sie schrieben am Donnerstag, 19. Juli 2001, 20:24:17:
> Hi
> I have been searching through the manual an