Nolan Rumble schrieb:
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
why is it complex?
It's a simple JOIN then. Isn't it?
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
