List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 22 1999 11:31pm
Subject:Re: Text file commands syntax error, ok interactively?
View as plain text  
At 3:48 PM -0700 6/22/1999, S. Whitmore wrote:
>I realize I'm probably missing something simple...  But here's the
>deal:  I have a text file that has a bunch of INSERT statements
>(generated from VFP, I figured it would be a simple way of moving data
>over).  If I run those commands from the command line like this:
>   mysql < vfpdata.txt
>(the real command includes switches to get to the right host, port,
>database, etc.), I get a syntax error on the first line.  If I copy
>that line and paste it, verbatim, into the mysql interactive command
>prompt, it works fine.  This doesn't make sense to me, and I don't
>know where to begin looking in the manual for something that would
>enlighten me.  The section about running commands from a text file
>doesn't mention any syntax caveats.  I can't think of anything that
>would be wrong from a text file but right from the interactive prompt.

Show us what happens, including the error message and what the first
line of the file looks like.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
Text file commands syntax error, ok interactively?S. Whitmore23 Jun
  • Re: Text file commands syntax error, ok interactively?Paul DuBois23 Jun
    • Re: Text file commands syntax error, ok interactively?S. Whitmore24 Jun
      • Re: Text file commands syntax error, ok interactively?Martin Ramsch24 Jun
    • Re: Text file commands syntax error, ok interactively?Garrick Staples24 Jun