On Wed, November 9, 2005 11:05 am, Chris W wrote: > Richard Lynch wrote: > >>On Sun, November 6, 2005 2:17 am, Chris W wrote: >> >> >>>I just tried to use the output of the export function on phpmyadmin >>>and >>>got a million errors. After looking at the file I found that >>> certain >>>columns that are strings were not quoted at all. I can't find any >>>reason why some are and some are not quoted. Anyone have any idea >>> why >>>this is happening? >>> >>> >> >>Because unless a field contains a ',' or '"' character, it doesn't >>NEED quotes to delineate it: >> >>1,test,3 >>1,"I said,""It's not the same""",3 >> >>is the same thing as: >>1,"test",3 >>1,"I said,""It's not the same""",3 >> >>Your import function is BROKEN in a major way, by requiring quotes >>where they are not strictly necessary to conform to the CSV >>specification. >> >>That said, it's probably easier to get phpMyAdmin to always quote the >>output than it is to fix whatever broken import tool you are using. >> >> >> > The program I am using to import the data is the MySQL tools. They > don't like the output of phpMyAdmin 2.6.1-rc1. And I don't have any > control over the server so I can't upgrade the version either. Unless > I > find a work around, I'm SOL
You could probably import into something smart enough to handle the missing quotes, then export with a setting that always quotes. I believe Excel (gak!) would do this correctly. PHP's http://php.net/fgetcsv might do the right thing, and you could write out the CSV any which way you want... Or, at that point, just write an INSERT query. Which route to take depends how big the file is, and how often you have to do this and what tools you are familiar with. -- Like Music? http://l-i-e.com/artists.htm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
