First off for those MySQL newbies in the crowd you might find this helpful, I compiled it a while ago but I am pretty sure it is still accurate:
http://www.residualselfimage.com/mysql_pkt_ref/ Essentially you need to start with the mysql documentation, or a beginners guide on that, then check out perldoc DBI (http://search.cpan.org/author/TIMB/DBI-1.30/DBI.pm) DBI lets you connect to the database and send queries to it. Queries being just about any SQL (including create and drop tables, selects, updates, inserts, etc.) Once you have a handle (no pun intended) on how DBI works what you can do is pretty much limitless (again no pun intended) (at least within the confines of Perl, which at times appear limitless :-)). I would give it a try and the post specific questions after looking into DBI. http://danconia.org/ dan wrote: > I'm in the process of writing IRC Services in Perl. I know most of you won't > know anything about IRC in this aspect at least. However what I need help > with is being able to store the services' data in a MySQL database. I know > absolutely nothing about MySQL. At the moment it's using a flat text file > database, and it gets sluggish at points when it starts saving. So I thought > it may be easier/faster reading from a MySQL database. Since I know nothing > about MySQL, how would I go about: > a) creating the "tables" for the services to read, and how to put different > bits of data there, and how to call them back without having to foreach > through a big list? > b) writing the code so perl connects to MySQL and stays connected for the > entire time the process is live, so it can read/write data from/to the > database > c) making a web accessible interface to use the same database as the > services, to provide real-time live statistics to the web, to enable website > users to view certain portions of the database > > All help muchly appreciated > > Dan > > > -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
