> Hi.. > I have 30 text file that contains of sort of data about > wheather...Each text file contains the information about > weather in one day. So, i have 30 text file, which contains > all the info about weather in 30 days(1 month). All the > attributes in all the text files are same (date, date, rain > scalar, celcius), but the the data / value in there are > absolutely different. So, how i can dump all this data into > mysql?...I have create a table named weather in Mysql, and > the attributes in this table are same with my text files... > My question is, how can I dump all the data from text file > into mySQL without specifies the names of the text file..It's > mean that, we only specifies the extention of text file > (*.txt) then by that way i can dump all into mysql?... > Did i need to develop some PERL script to read an extension > (.txt) and read them then import them into mysql or mysql > itself provide some sommand to do so?... >
First, read the documentation for MySql to find out if there is a tool do dump this data into tables. I use Oracle and it has a nice tool for this kind of thing. If you are going to be doing this kind of stuff, you had better start learning Perl DBI. Google for it, install it and read and learn.. Jim --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.772 / Virus Database: 519 - Release Date: 10/1/2004 -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
