From: Bill Koob
Date: March 16 1999 12:15am
Subject: Need to understand process
List-Archive: http://lists.mysql.com/mysql/286
Message-Id: <3.0.5.32.19990315181505.00806d70@minn.net>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"


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.