On Tue, 18 Jun 2002, Brad W. Galiette wrote:
> I am currently in the process of designing a database solution that requires > columns to have array-like capabilities. To provide the group with a better > notion of what I am trying to accomplish, please review the following > example. > As far as I know, no relational database supports columns with array or list types (known also as "non-simple domains", if you're into the theory). It's one of those normal form things. <snip> > code processor-intensive. Second, an arrangement with a second table could > be created with the following format: > notify_table: > user_id|event_id|notify_datetime|notification_sent > > In this manner, the background daemon would query the notification-data-only > table for all events that have notification times less than or equal to the > present ( SELECT event_id FROM notify_table WHERE now() >= notify_datetime > && notification_sent = 0 ) and given the <event_id>s returned, identify the > proper user and corresponding event. While this is the most > architecturally-sound possibility that I am familiar with, it would be more > convenient to retrieve an event's contents in the same query that identifies > those items which need to initiate notification. Thus the original > question: is an array-like data type possible in MySQL, and if so, how? > Would a JOIN not work to make a single query? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
