On Fri, Dec 06, 2002 at 01:35:04AM +0100, Alliax wrote: > Since there is no common denominator for opening times, I thought of having > another table with 28 (!!) fields. I'm doubtful this is optimal. As opposed to something like:
RestTimes ( id ..., restaurantid ..., weekday tinyint unsigned, open ..., close ..., label varchar ); select label, open, close where restaurantid = ... and weekday = ...; -- Michael T. Babcock sql CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
