Database functions.

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Dear monks,

What are important functions in perl using mysql. for eg. like fetchrow_array, we use to get data's from the database. Likewise, any functions and uses, any important notes available regarding the database function means please mention the notes or mention the functions and uses.
Thanks.

Comment on Database functions.

Replies are listed 'Best First'.
Re: Database functions. by jZed (Prior) on Apr 23, 2005 at 01:06 UTC
fetchrow_array() is a method of the DBI module. It's documentation lists many methods. DBD::mysql is the companion module you will need to work with DBI. It's documentation has a few additional methods although most of its usage will be through DBI. See also the DBI website and Tutorials.	[reply]
Re: Database functions. by jpeg (Chaplain) on Apr 23, 2005 at 00:56 UTC
Do you know about perldoc? typing `perldoc DBD::mysql` at a prompt will tell you what you need to know and more.	[reply] [d/l]
Re: Database functions. by hubb0r (Pilgrim) on Apr 23, 2005 at 04:24 UTC
As the others have said, the docs cover everything you need to know about what functions are available. If you read perldoc DBI you will get 99% of the knowledge that you need to communicate effectively with whichever database you are using on the backend. The number of functions available to you are too numerous to enumerate here, but there is a lot more than just fetchrow_array as I'm sure you've figured out. Not sure how the perldocs work on windows, but on a nix just `perldoc DBI` [download] and since DBI is a module, the full documentation is available over on CPAN: DBI	[reply] [d/l]
Re: Database functions. by derby (Abbot) on Apr 23, 2005 at 11:03 UTC
check out Before asking a database related question .... -derby	[reply]
Re: Database functions. by Anonymous Monk on Apr 26, 2007 at 00:56 UTC
I found this site useful too. Gives information about database functions. http://www.perl.com/pub/a/2003/10/23/databases.html Shashidhar Iddamsetty	[reply]