On 03-Jul-01 Clif Wieden wrote:
> I have a project where the admin uploads a new data file and it needs to
> be loaded into a mysql database. What's the best way to do this? The
> data file is tab-delimted but could be reformatted.
>
> Right now the file is uploaded and after copy($new_file, $file_loc)
> would like to refresh the db.
>
LOAD DATA INFILE 'filename' into da_table ...
the MySQL manual has the details.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
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]
