List:General Discussion« Previous MessageNext Message »
From:Bill Koob Date:March 16 1999 12:15am
Subject:Need to understand process
View as plain text  
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.

Thread
Need to understand processBill Koob16 Mar
  • Re: Need to understand processPaul DuBois16 Mar