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
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:
Hi
I added the following statement at the end of the my.cnf file:
sql-mode=STRICT_ALL_TABLES,ALLOW_INVALID_DATES
but I still got the values 0 and 0.00 where no values were entered.
I did restart the the mysql daemon of course.
What am I still doing wrong?
Thanks.
On 8/8/07, Christian High
I did remove that column from the insert statement and no text appeared at
all in that field under that column. Not even the word NULL.
On 8/8/07, Christian High [EMAIL PROTECTED] wrote:
On 8/8/07, Brent Baisley [EMAIL PROTECTED] wrote:
One thing to check is to make sure you are not quoting
Could the commas at the end of your data lines be causing a problem? (I've
never loaded a CSV file.)
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
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...
Now, I went through on a few of them and added \n to the end of the
line, then tried to load the file again with the LINES TERMINATED BY
\n and it looks
Doesn't that (the trailing comma) depend upon whether or not you want the
default value for the (missing) field, as opposed to or 0 used for empty
fields?
Either way, you are right - you should be able to import the data.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
IF it is a null in that column, you should not see the word 'null'..
and the advise to put quotes around it I read earlier in this thread
is completely misguided.. If you insert the string 'null' or 'NULL'
into the database, you have just strored a string..
Perhaps it is the form of your
I have been pulling my hair out over a temporary table being created in the
following query
SELECT SQL_NO_CACHE SQL_CALC_FOUND_ROWS entryid,title FROM
friends_test INNER JOIN entries ON friendLink=userid AND userLink=2 order by
entryid
if I change userLink=2 to friendLink=2 it is fine and its
It goes to a temporary table when MySQL does not have enough memory
(allocated) to store the temporary results in memory, so it needs to create
a temporary table on disk.
Try increasing the memory buffer size or eliminating more rows from the
query.
-Original Message-
From: Mike Zupan
11 matches
Mail list logo