cat thefilename | mysql -u -p dbname
--Greg Johnson
-Original Message-
From: David Turner [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 2:13 PM
To: [EMAIL PROTECTED]
Subject: Run a file from mysql prompt
How do I get a file full of sql commands to run
from the mysql
Cool, thx.
Dave
On Fri, Feb 01, 2002 at 01:21:18PM -0600, Paul DuBois wrote:
> At 11:12 -0800 2/1/02, David Turner wrote:
> >How do I get a file full of sql commands to run
> >from the mysql prompt?
>
> mysql> source filename;
>
> or
>
> mysql> \. filename;
>
>
> >
> >
> >In oracle I would t
At 11:12 -0800 2/1/02, David Turner wrote:
>How do I get a file full of sql commands to run
>from the mysql prompt?
mysql> source filename;
or
mysql> \. filename;
>
>
>In oracle I would type
>
>
>@thefilename
>
>I know how to do run the file from the unix prompt mysql < thefilename.sql
>
>Tha
How do I get a file full of sql commands to run
from the mysql prompt?
In oracle I would type
@thefilename
I know how to do run the file from the unix prompt mysql < thefilename.sql
Thanks, Dave
-
Before posting, please ch