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

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 || | Ryan Russo | | Academic Computing Web

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

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

Re: win start problem

, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com || | Ryan Russo | | Academic Computing Web Group, (518) 442-4772

A difficutl query I cannot do.

be 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