Very new member.
This is first attempt to create a table and put
some data in it on a win95 machine running
server version 3.21.29a-gamma-debug prot
ver 10
from /bin
/bin>mysqld
/bin>mysql test
/bin>mysqladmin
mysql>CREATE TABLE first (
mysql>recnbr INT PRIMARY KEY
mysql>name char(15)
mysql>);
This code would not work until I put a , after KEY
mysql>LOAD DATA LOCAL INFILE 'mydata.txt'
mysql>INTO TABLE first
mysql>FIELDS TERMINATED BY ','
mysql>OPTIONALLY ENCLOSED BY '"'
mysql>;
mysql>go
Get error msg 1061 error near LOCAL
Any help appreciated.
Have a great Hunt
wkoob@stripped
WetDog owned by Wet Dogs
http://www1.minn.net/~wkoob/
My personality is something like this
Mit der dumheit nicht gotter selbst vergeben.
