Re: How to create table in this case

2001-02-09 Thread Canadian Lumberer
Hi, On Fri, Feb 09, 2001 at 05:51:08PM +0530, Suresh Kumar R wrote: > In this table the entries would look like this: > > student_idhour_of_day day_of_week week_of_course > > 1 1 1 1 > 6 1 1

Re: How to create table in this case

2001-02-09 Thread Suresh Kumar R
Hi, Thanks for your comments. In this table the entries would look like this: student_id hour_of_day day_of_week week_of_course 1 1 1 1 6 1 1 1 14 1

Re: How to create table in this case

2001-02-09 Thread Russell King
From: Suresh Kumar R <[EMAIL PROTECTED]> > I want to have the absentee list of students per hour_of_day per day for a week, done for the entire course. > > One possibility I thought was to create a table with date and each hour of the day as columns, then each cell would have to have variable num

How to create table in this case

2001-02-06 Thread Suresh Kumar R
Hi, I want to create a database for managing the attendance statements of students under my supervision. I have mysql running on a debian machine (version 3.22.32-4). I am unable to create the required tables as I am afraid I need a two dimensional array which is not available(as I know) in my