On Aug 8, 2007, at 5:19 PM, Gary Josack wrote:
Try:
|load data local infile '|/volumes/raider/aml.master.8.6.07.|csv'
into table test fields terminated by ',' enclosed by '' lines
terminated by '\n' |ignore 1 lines
|(First, Last, Add1, Add2, City, State, Zip, XCode, Reason, Date);
If
-Original Message-
From: Jason Pruim [mailto:[EMAIL PROTECTED]
Sent: 09 August 2007 14:16
To: Gary Josack
Cc: mysql@lists.mysql.com
Subject: Re: Import file into MySQL Database..
On Aug 8, 2007, at 5:19 PM, Gary Josack wrote:
Try:
|load data local infile '|/volumes
On Aug 9, 2007, at 10:11 AM, Edward Kay wrote:
-Original Message-
From: Jason Pruim [mailto:[EMAIL PROTECTED]
Sent: 09 August 2007 14:16
To: Gary Josack
Cc: mysql@lists.mysql.com
Subject: Re: Import file into MySQL Database..
On Aug 8, 2007, at 5:19 PM, Gary Josack wrote:
Try
www.etudes-marche.com
-Original Message-
From: Jason Pruim [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 09, 2007 10:54 AM
To: Edward Kay
Cc: mysql@lists.mysql.com
Subject: Re: Import file into MySQL Database..
On Aug 9, 2007, at 10:11 AM, Edward Kay wrote:
-Original
:[EMAIL PROTECTED]
Sent: Thursday, August 09, 2007 10:54 AM
To: Edward Kay
Cc: mysql@lists.mysql.com
Subject: Re: Import file into MySQL Database..
On Aug 9, 2007, at 10:11 AM, Edward Kay wrote:
-Original Message-
From: Jason Pruim [mailto:[EMAIL PROTECTED]
Sent: 09 August 2007 14:16
@lists.mysql.com
Subject: Re: Import file into MySQL Database..
The Extra commas at the end of some of the lines need to be there to
keep everything in the right order, they represent empty fields...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
If you can import your excel doc into MS Access I'd suggest:
http://www.mysql.com/products/tools/migration-toolkit/
I just started using and love it - easy intutitive GUI tool for importing
data into nySQL databases.
Good luck.
-Original Message-
From: Jason Pruim [mailto:[EMAIL
A... the one thing I can't do... I don't have Access to well...
Access... :)
Did some more testing, made a new table and matched the field names,
now it will load it without any errors, it's just only importing the
first row... Not the rest of the 934 records...
On Aug 8, 2007, at
Hi.
On Wednesday 08 August 2007 18:39, Jason Pruim wrote:
Did some more testing, made a new table and matched the field names,
now it will load it without any errors, it's just only importing the
first row... Not the rest of the 934 records...
You are using ENCLOSED BY '' in your SQL, which I
Jason Pruim wrote:
Okay, so I have been going crazy trying to figure this out...
All I want to do is load a excel file (Which I can convert to just
about anything) into a MySQL database... Should be easy right?
Here is the command that I have tried: LOAD DATA LOCAL INFILE
First line of my .csv file is:
First,Last,Add1,Add2,City,State,Zip,Date,Xcode,Reason
DESCRIBE is:
mysql describe test;
++-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
++-+--+-+-+---+
| First
I believe that excel files generally terminate lines with '\r\n' and
if you use terminated by '\n' it will cause this behavior. so try it
with lines terminated by '\r\n' or get TextPad or a similar editor
that can save the file as unix platform that uses the same line
terminators that MySQL
Jason Pruim wrote:
First line of my .csv file is:
First,Last,Add1,Add2,City,State,Zip,Date,Xcode,Reason
DESCRIBE is:
mysql describe test;
++-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
13 matches
Mail list logo
