On Tue, 2004-10-19 at 12:12, Roime bin Puniran wrote: > 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?...
HI, I guess no, quite sure, that MySQL has an import feature. Try to check the documention. Good luck Gabaux -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
