Re: Run a file from mysql prompt

2002-02-01 Thread Paul DuBois
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 Thanks, Dave

Re: Run a file from mysql prompt

2002-02-01 Thread David Turner
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 type

RE: Run a file from mysql prompt

2002-02-01 Thread Johnson, Gregert
cat thefilename | mysql -uuser -ppassword 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