Re: mysql sql files...

[Paul DuBois]

At 17:21 -0700 7/4/04, bruce wrote:
>hi..
>
>i can run sql files that have sql statements by :
>  shell:>mysql -u -p <foo.sql
>
>is there a way to run foo.sql if i'm already inside the mysql env...
>
>neither a search of google/mysql indicates that you can...

You don't have to use Google.  Just read the section on the mysql
program in the MySQL Reference Manual.

http://dev.mysql.com/doc/mysql/en/mysql.html

In particular, this subsection:

http://dev.mysql.com/doc/mysql/en/Batch_Commands.html


-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com