mm.. I'm not sure what you're trying to achieve here?
Why do you want an array in there? I'm pretty sure it's not possible
(correct gang?), but I'm wondering why you'd want that.
What you *can* do is just store a serialized array in a textfield.
What i'm trying to do is dump a log file into a table. This log file
contains various information like message ID, timestamp, etc. One of the
fields in the logfile is a variable length --> recipients.
So what i'd like to do is when I generate usage reports, for example, how
many messages a user sent and received, then I can do something like the
following:
SELECT COUNT(*) FROM temp GROUP BY recipient;
and it will list all the email addresses and how much email they
sent/received.
I suppose I can create another table which handles the variable length
recipients but I would like to avoid that as that would make the SQL
statements very complex and very hard to administer.
Thanks
NOlan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
