RE: [PHP] SQL Server DB to mySQL DB

Thanks for the tip. I actually read that the default for mySQL is TAB and LF for delimiters, so I used those in SQL and exported a .txt file, imported it into mySQL database and voila! A few code modifications and we be running on mySQL. Thanks again! Jason -----Original Message----- From: Christopher Allen [mailto:callen@driver8.org] Sent: Thursday, January 25, 2001 9:16 AM To: Jason Bouwmeester; php-general@lists.php.net Subject: Re: [PHP] SQL Server DB to mySQL DB Just did this to a 65mb fixed width file. What I did was get it into a csv file via perl :) Then I created the db table. Then I used: load data infile "/file.csv" into table blah fields terminated by ',' ; then go ahead and create any indexes etc... !works slick! > Is there an easy way to do this? I know that SQL Server can export a comma > delimited file, can mySQL import this? I imagine the PHP will be easy to > modify as long as the field names are the same.