How do I get the file names from a certain directory in SQL?

Hi all, How do I get the file names from a certain directory in SQL? Thanks, Siva -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How do I get the file names from a certain directory in SQL?

Hey, How do I get the file names from a certain directory in SQL? It seems to me that you're trying to do things that are beyong SQL really. SQL is about the database, not about a file system. Yes, by creating a DBMS that allows you to write functions that interact with the file system, you

Re: How do I get the file names from a certain directory in SQL?

On Thu, 2008-07-24 at 17:36 +0530, Sivasakthi wrote: Hi all, How do I get the file names from a certain directory in SQL? SQL is designed to deal with RDBs, not the rest of the computer system. I suggest you switch to a modern language such as Perl, Python, Ruby, or even PHP. Each has a

Re: How do I get the file names from a certain directory in SQL?

Martijn Tonies wrote: Hey, How do I get the file names from a certain directory in SQL? It seems to me that you're trying to do things that are beyong SQL really. SQL is about the database, not about a file system. Yes, by creating a DBMS that allows you to write functions that

Re: How do I get the file names from a certain directory in SQL?

I accept that.. but my requirement is , I have some no of Excel files..I just need to check the modified time of the files ,if it is modified currently then I need to open those files and convert the excel data to database.. otherwise i didnt change anything in my database.. how can i