INSERT directory paths into MySQL table

Good Day,

I have a directory of files on my webserver, who's paths I would like to upload into a column of a MySQL table.

I'm thinking I'll have to write a PHP script to do this, but being the lazy guy I am, I am curious if anyone else has a better way. Any input?

Thanks in advance,

Milty

 

I've got it! (With some help )

What I did was get a directory listing in a text file using DOS commands:

Code:

[B]dir[/B] <[I]directoryname[/I]> /s /b >> c:\directorylisting.txt

And once there, I used a SQL command to upload the list into my table:

Code:

LOAD DATA INFILE 'c:/directorylisting.txt' INTO TABLE <[I]tablename[/I]> (<[I]columnname[/I]>);

This has put a list of 2,780 file paths into my SQL table in a matter of microseconds! SO RAD! http://forums.majorgeeks.com/images/icons/icon14.gif