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/
