array type

2006-07-04 Thread Nolan Rumble
Hi, Is it possible to create a table which has an array type in it? For example, something like: CREATE TABLE temp (id INT, email[] TINYTEXT); Thanks Nolan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: array type

2006-07-04 Thread Nolan Rumble
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

Re: array type

2006-07-04 Thread Duncan Hill
On Tuesday 04 July 2006 16:21, Nolan Rumble wrote: 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

Re: array type

2006-07-04 Thread Barry
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