tricky timetable based query

2004-06-18 Thread Sam Russo
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

2002-03-11 Thread russo

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

2002-03-05 Thread russo

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




Re: win start problem

2002-03-04 Thread russo

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 .
> 04/03/2002  10:07 ..
> 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




win start problem

2002-03-04 Thread russo

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\bin>mysqld-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




A difficutl query I cannot do.

2002-01-09 Thread Sam Russo

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