Quoting Richard Lynch <[EMAIL PROTECTED]>: > 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] >
-- Dwayne Hottinger Network Administrator Harrisonburg City Public Schools -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
