Re: Default search directory for SOURCE command?

2004-05-15 Thread Paul DuBois
At 15:05 -0500 5/15/04, Josh Trutwin wrote: On Sat, 15 May 2004 14:38:52 -0500 Paul DuBois <[EMAIL PROTECTED]> wrote: >Is there something similar in MySQL? No. Dang - oh well. :) >Also, any idea why SOURCE filename.sql; works in MySQL 5.0.0 and \. > >filename.sql; does not? Leave out the t

Re: Default search directory for SOURCE command?

2004-05-15 Thread Josh Trutwin
On Sat, 15 May 2004 14:38:52 -0500 Paul DuBois <[EMAIL PROTECTED]> wrote: > >Is there something similar in MySQL? > > No. Dang - oh well. :) > >Also, any idea why SOURCE filename.sql; works in MySQL 5.0.0 and \. > > > >filename.sql; does not? > > Leave out the trailing semicolon for short-f

Re: Default search directory for SOURCE command?

2004-05-15 Thread Paul DuBois
At 14:27 -0500 5/15/04, Josh Trutwin wrote: Hi, I teach a class using Oracle and MySQL and I store a few things like creating tables for student labs in SQL files. I have them load these files by typing: SOURCE filename.sql; from the MySQL prompt. A nice feature in Oracle is that you can set a

Default search directory for SOURCE command?

2004-05-15 Thread Josh Trutwin
Hi, I teach a class using Oracle and MySQL and I store a few things like creating tables for student labs in SQL files. I have them load these files by typing: SOURCE filename.sql; from the MySQL prompt. A nice feature in Oracle is that you can set a default path where the client looks for t