At 1:42 PM -0400 04-04-2000, 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;
"<" works from the DOS prompt, not from within the mysql program.
And your file would need to contain SQL statements. If what your
file contains is just data rows that you want to read into a table,
use LOAD DATA LOCAL to read it into your table:
mysql> LOAD DATA LOCAL INFILE "profile.txt" INTO TABLE your_table_name;
You might need to supply field and line options on the statement, depending
on the format of your data.
>
>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)
>
>TIA,
>Margie
--
Paul DuBois, paul@stripped
