MySQL Lists are EOL. Please join:

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>mysql test
>mysql>CREATE TABLE first (
>mysql>recnbr INT PRIMARY KEY
>mysql>name   char(15)
>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
>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:
Madison Black Wolf:
Need to understand processBill Koob16 Mar
  • Re: Need to understand processPaul DuBois16 Mar