tricky timetable based query

I recieve a delimited file whose fields are: day,slot,subject,room An example of this file is: 2,1,Mat,R1 3,1,Sci,R6 1,2,Sci,R6 3,2,Mat,R3 1,3,Eng,R2 2,3,Eng,R5 1,4,Mat,R7 3,4,Eng,R9 I need a mysql query that will generate a timetable which looks like: Day1Day2Day3

Re: MySQL and MSAccess

se 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 unsubscribin

Re: win start problem

Ok, I'm an idiot. I haddatadir = c:/_data/mysql/ when I should have had datadir = c:/_data/mysql/data/ I had some help though (I can't place all the blame on myself, ego issues ya know). I find this paragraph utterly confusing in MySQL Ref. Manual version 4.0.2-alpha See "Node Windows pre

Re: win start problem

nnodb_lock_wait_timeout=50 > > Notice above the files sizes and memory values which you should > change according with your machine and necessities. > > Start the server. > > Regards, > Miguel > > > -- > For technical support contracts, goto https://order.mysql.com/ > __ ___ ___ __ &g

win start problem

Hi All, New to mysql. Running: Win2k as Administrator mysql-3.23.49-win.zip (binaries) Keep getting error (complete output below sig): mysqld: Table 'mysql.host' doesn't exist I've tried running each binary msqld version (mysqld, mysql-max). I haven't seen any soluti

A difficutl query I cannot do.

appreciated. sam russo [EMAIL PROTECTED] - 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]&