> Pete wrote:
> > Hi folks --
> >
> > What would be the right approach in MySql 5.0?
> >
> > My table, USERS, has columns NAME and IP. Associated
> with each user is also a collection of from 0 to 50 INTs.
> What's a reasonable way to put these 50 INTs in the table
> without using 50 separate columns, INT01...INT50? Is BLOB an
> OK approach?
> >
> > I have to manipulate these INTs in my CGI code.
> >
> > Thanks!
> >
> > -- Pete
> >
>
>
> Break them out into a separate table linked via the primary
> key.
How elegant! Thanks.
-- Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
