MySQL has a column type for that, so you don't have to use an INT or BIGINT:
http://www.mysql.com/doc/S/E/SET.html --jeff ----- Original Message ----- From: "Harald Fuchs" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 03, 2002 4:19 AM Subject: Re: Strategies for maintaining tables calculated from other tables? > In article <[EMAIL PROTECTED]>, > "Nick Arnett" <[EMAIL PROTECTED]> writes: > > > I'm finding that it's not quite as simple as I had imagined to maintain a > > table whose values are calculated by analyzing other tables. The source > > tables contain time series data, which can is updated several times a day. > > To calculate totals by day, week, month, etc., I don't want to have to start > > over from scratch, so I want to keep track of which records in the source > > tables have already been analyzed. Further complicating things, there are > > several analyses that take place and I may add others later. I don't always > > want to have to do all of them at the same time. > > > So, at the moment, I've added some Boolean enum columns to the source data > > tables, showing which analyses have been done. Do the analysis, set the > > Booleans to true. I'm not sure I really like that approach, since it can > > mean adding columns to rather large tables at times. > > How about adding a single INT or BIGINT column which you treat as a > bit string in your application (presuming you don't ever have more than 32 > resp. 64 analyses). > > > Just to make it all a bit more complicated, the initial analysis is done in > > a temporary table, for huge performance gain, then inserted into its final > > resting spot. > > This should not matter as long as you set your flags after the final > INSERT has been done. > > > P.S. sql,query (to satisfy that danged filter) > > Me too ... > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
