|
|
Posted by Rik Wasmus on 12/09/07 08:33
On Sun, 09 Dec 2007 06:53:29 +0100, myGoogle71 <ali711@sunnipath.com>
wrote:
> Hi,
> I have to import hundreds of file to MySQL database. Is it
> possible to write a script/storedprocedure in MySQL that does this
> without manually doing it for each file.
> Say file names are of type 'file0001.txt', 'file0002.txt' etc. Does
> MySQL provide any such utility or does anyone know of a free utility?.
> If not then what is best language to write such a script/program. Cant
> such a script be written in PHP easily?
Easily written. Check the glob() function in PHP & de LOAD_FILE() function
in MySQL.
--
Rik Wasmus
Navigation:
[Reply to this message]
|