You van use the LOAD DATA INFILE statement Check this http://www.mysql.com/doc/en/LOAD_DATA.html
for more information HTH Dobromir Velev [EMAIL PROTECTED] www.websitepulse.com ----- Original Message ----- From: "Andrew" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 30, 2003 12:48 Subject: RE: sql CSV import > > Hi all I am trying to import a csv file from MySQL and keep getting an error on > line one. > Is there an alternative way to import a csv file other than using phpmyadmin? > > I exported the file from MySQL but can't import it back in, any ideas? > > Andrew > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php