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:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 9:16 AM
To: Jason Bouwmeester; [EMAIL PROTECTED]
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.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
