Pete Wilson 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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
