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 --- 1 Mat R1 Sci R6 2 Sci R6 Mat R3 3 Eng R2 Eng R5 4 Mat R7 Eng R9 Any help would be appreciated sam ** This message is intended for the addressee named and may contain privileged information or confidential information or both. If you are not the intended recipient please delete it and notify the sender. **
Re: MySQL and MSAccess
Hi Chris, Also interested in exploring how MS products can interact with MySQL since I work in a diverse environment (PC's, some MACs, UNIX clusters-Solaris 8). I found this so far: http://www.mysql.com/doc/M/y/MyODBC_clients.html Also, to check which version of MDAC you have use: Component Checker http://www.microsoft.com/data/download.htm#CCinfo That's all I have I'm fairly new to most of this... I'm hoping other list members have more to say. ;) Regards, -Ryan On Mon, 11 Mar 2002, Chris Becker wrote: Is anyone out there using MySQL on either Unix or NT, with MSAccess as the front-end? Are you using odbc bound controls on your access forms? Any issues? Suggestions? In-sights? We are planning on migrating a SQLServer back-end to MySQL on Linux as a robust and affordable back office solution. Thanks in advance. Chris _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - 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 || | Ryan Russo | | Academic Computing Web Group, (518) 442-4772 | || - 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
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 prepare environment #- [mysqld] basedir=the_install_path #e.g. c:/mysql datadir=the_data_path #e.g. c:/mysql/data or d:/mydata/data If the data directory is other than the default c:\mysql\data, you must cut the whole \data\mysql directory and paste it on the your option new directory, e.g.: d:\mydata\mysql. #- And, many of the user comments listed here: http://www.mysql.com/doc/N/T/NT_start.html seem to indicate there were problems when trying to _install_ in a non-standard location. There _may_ be. But, it seems the datadir path is respected (works) fine (although I didn't try a path name with spaces) Miguel, Thanks again for your time. Thanks to your persistance I have MySQL installed with the data where I want it. :) -Ryan [Chop] I need to confess you, that until now I didn't have in my mind to use a directory name like __work. However I created the f:\__work dir (on my machine I have the Win2K on F:), cut/paste the whole directory \mysql\data to \__work and modified the my.ini for to have the datadir like: datadir=f:\__work\data (notice that you did c:\__work\data\mysql). With the changes above, I ran the server without any problem. Regards, Miguel I get the same error. Note: I did copy the c:\mysql\data tree (with all files to the non-standard location and modified the my.ini). Anyway, I went back to the original machine and got it working by pointing back to the standard c:\mysql\data dir for all files I don't like this but, it works Thanks Anyway For Your Response, -Ryan [Chop] - 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
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 solutions to this problem on the web (google) other than one person suggesting to someone with the same error that they didn't have privileges to write the table. And another saying they needed to re-run mysql_install_db ( I didn't get this with the binary dist.) At a loss... -Ryan [My first run] C:\mysql\binmysqld-max-nt --standalone --console InnoDB: The first specified data file c:\_data\mysql\innodb\ibdata1 did not exis t: InnoDB: a new database to be created! 020301 14:17:38 InnoDB: Setting file c:\_data\mysql\innodb\ibdata1 size to 400 MB InnoDB: Database physically writes the file full: wait... 020301 14:18:16 InnoDB: Log file c:\_data\mysql\innodb\ib_logfile0 did not exis t: new to be created InnoDB: Setting log file c:\_data\mysql\innodb\ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 020301 14:18:16 InnoDB: Log file c:\_data\mysql\innodb\ib_logfile1 did not exis t: new to be created InnoDB: Setting log file c:\_data\mysql\innodb\ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... 020301 14:18:17 InnoDB: Log file c:\_data\mysql\innodb\ib_logfile2 did not exis t: new to be created InnoDB: Setting log file c:\_data\mysql\innodb\ib_logfile2 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 020301 14:18:22 InnoDB: Started - 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
Re: win start problem
Hi Miguel, Yes, they are there. Already had the my.ini set up in c:\winnt since I needed to specify a non-standard location for my data files. (I used the medium conf. file included with the binaries as a starting point). UPDATE: I decided to try the install on a different Win2k machine slightly different build. It worked with files in standard location specified in a my.ini (c:\mysql\data). I added innodb support. Still worked. However, when I tried to change the data output to c:\__work\data\mysql... I get the same error. Note: I did copy the c:\mysql\data tree (with all files to the non-standard location and modified the my.ini). Anyway, I went back to the original machine and got it working by pointing back to the standard c:\mysql\data dir for all files I don't like this but, it works Thanks Anyway For Your Response, -Ryan On Mon, 4 Mar 2002, Miguel Angel Solorzano wrote: At 13:22 04/03/2002 -0500, [EMAIL PROTECTED] wrote: Hi! 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 Take a look in the \mysql\data\mysql directory if there are the grant tables, like below: Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-1999 Microsoft Corp. f:\dir f:\mysql\data\mysql O volume na unidade F é WIN2K O número de série do volume é 8C89-59D6 Pasta de f:\mysql\data\mysql 04/03/2002 10:07 DIR . 04/03/2002 10:07 DIR .. 06/10/2001 19:338.778 columns_priv.frm 06/10/2001 19:330 columns_priv.MYD 06/10/2001 19:331.024 columns_priv.MYI 06/10/2001 19:338.982 db.frm 06/10/2001 19:33 151 db.MYD 06/10/2001 19:333.072 db.MYI 06/10/2001 19:338.641 func.frm 06/10/2001 19:330 func.MYD 06/10/2001 19:331.024 func.MYI 06/10/2001 19:338.958 host.frm 06/10/2001 19:330 host.MYD 06/10/2001 19:331.024 host.MYI 06/10/2001 19:338.877 tables_priv.frm 06/10/2001 19:330 tables_priv.MYD 06/10/2001 19:331.024 tables_priv.MYI 06/10/2001 19:339.148 user.frm 06/10/2001 19:33 428 user.MYD 06/10/2001 19:332.048 user.MYI 18 arquivo(s) 63.179 bytes 2 pasta(s) 17.428.426.752 bytes disponíveis If you don't find them, re-install the MysQL stuff again. Before to run the server, delete the first files that InnoDB has created. Create manually two directories (for the InnoDB data\log files): c:\ibdata and c:\iblogs Now create on \winnt the file called my.ini and edit the below contents: [mysqld] basedir=c:/mysql datadir=c:/mysql/data innodb_data_file_path = ibdata1:200M innodb_data_home_dir = c:\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=18M innodb_flush_log_at_trx_commit=0 innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=5M set-variable = innodb_additional_mem_pool_size=5M set-variable = innodb_file_io_threads=4 set-variable = innodb_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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com || | Ryan Russo | | Academic Computing Web Group, (518) 442-4772 | || - 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
A difficutl query I cannot do.
I have a delimited file sent to me with students ID subjects and when they do these subjects. This file (table) looks like: ID TimeSlotSubject 215 3 Eng1 648 2 Maths2 901 4 French 215 2 Maths1 901 1 Science2 648 4 Art 215 1 Science1 901 3 Eng1 I need to produce the following output (on a web page using php and mysql) with a mysql query. ID 1 2 3 4 215 Science1Maths1 Eng1 648 Maths2 Art 901 Science2Eng1 French any help would 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] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
