Re: [PHP-DB] CSV import to mySql

2006-12-05 Thread Chris 

Chris Carter wrote:

Hi,

I have this data given below as sample. Trying to import to mySQL is failing
everytime. There are more than 100 rows of data but when I follow the
procedure of phpMyadmin  databasename  tablename  click import tab from
top choose the file (csv file)  Click on the CSV radio button on Format
of imported file area  put Fields terminated by ,, Fields enclosed by ,
fields escaped by \ and Lines terminated by by auto (do not mention
anything in Column text box.


Sounds like something for the phpmyadmin guys to me.

http://sourceforge.net/mail/?group_id=23067

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] CSV import to mySql

2006-12-05 Thread Niel Archer 
Hi

Your example data does have an invalid field count  The first row has has
7 fields, the other 6. 

So if you took them from your actual data that's your problem

Niel

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php