From: Paul DuBois Date: March 16 1999 12:26am Subject: Re: Need to understand process List-Archive: http://lists.mysql.com/mysql/290 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" At 6:15 PM -0600 3/15/1999, Bill Koob wrote: >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 That's not surprising, because otherwise your statement isn't legal. >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 LOCAL wasn't added to LOAD DATA INFILE until 3.22.6. -- Paul DuBois, paul@stripped Northern League Chronicles: http://www.snake.net/nl/ Madison Black Wolf: http://www.primate.wisc.edu/people/dubois/blackwolf/