mySQL

Please choose the following question.

If you can't find your question, please let us know and we'll answer it in e-mail and add it to the FAQ.

1. What is the name of my mySQL database?
2. How I can query my mySQL database directly for debugging purposes?
3. Is there a perl API for mySQL?

What is the name of my mySQL database?

How I can query my mySQL database directly for debugging purposes?

/usr/local/bin/mysql --user=youracct -p youracct

Where youracct is your account name.

Is there a perl API for mySQL?

For more information refer to the documentation at http://mysql.he.net

Here is a quick demonstration of a generic query:

	use Mysql;

        if ( ! ( $gDBH = Mysql->Connect("servername",
                "database","passwd","user") ) )
        {
                die "SQL Error: $Mysql::db_errstr";
        }

        my $sth = $gDBH->query( "select * from tablename" );

        if ( ! defined $sth )
        {
                die "SQL Error: $Mysql::db_errstr";
        }

        for (;;)
        {
                my %hash;
                last if ! ( %hash = $sth->FetchHash() );

                foreach $key ( sort keys %hash )
		{
                        printf( "%16s: %s\n", $key, $hash{$key} );
                }

                print "\n";
        }

---

Call 1-800-THE-LOST if you've seen this child. Click on the image for case details. We support the work of the National Center for Missing and Exploited Children. Click Here To Add A Missing Child Link To Your Pages!