Now Place:2uzhan.com » inserting into MySQL from Perl

inserting into MySQL from Perl

MySQL @ August 16, 2006   Views:0


I am a beginner with Perl 5, I need to read a file in Perl and enter the extracted information into MySQL. How can I do this ??
Thanking in anticipation.


That's a pretty broad question for a forum posting! :-)

Teaching you everything you need to know about Perl or the DBI module to do the task you describe is beyond the scope of a forum posting. You need to do some reading.

The standard way of using a database from Perl is a module called DBI. There's plenty of documentation, you can find it here: http://dbi.perl.org/

There are also many Perl tutorials at perlmonks.com: http://www.perlmonks.com/?node=Tutorials

Here's one tutorial titled "DBI recipes". http://www.perlmonks.com/?node_id=284436 It includes examples of inserting data into a database using DBI. This link http://search.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/ might also be of an interest in order to learn more on dbi/dbd and perl/mysql.

Edit: forgot the link :P

Edited 1 time(s). Last edit at 08/20/2006 02:59PM by Apachez .

© 2018 2uzhan.com Contact