List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 16 1999 12:26am
Subject:Re: Need to understand process
View as plain text  
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/
Thread
Need to understand processBill Koob16 Mar
  • Re: Need to understand processPaul DuBois16 Mar