Margie Wiers wrote:
> Hello all,
>
> I've created a table in a text file (profile.txt) and now cannot get the
> mysql client to read from this file. According the the Manual (19.4) I
> should be able to do this. This is what I've done (in DOS)
>
> mysql>use mycolors;
>
> mysql>mycolors < profile.txt;
>
> And this is always what I get
>
> ERROR 1064: You have an error in your SQL syntax
>
> I've tried putting in the complete filepath, and using other variations, but
> can't get the mysql client to read this file. Can anyone help?
>
> My setup is PHP 3.0.xx / MySQL 3.23.12 / Apache 1.3.11 on Win95 (yes, I
> know)
Assuming profile.txt contains sql statements, and not a delimited file, try:
mysql mycolors < profile.txt
