On Wed, 3 Apr 2002, Nick Arnett wrote:
>
>
> > -----Original Message-----
> > From: Doug Bishop [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 03, 2002 10:13 PM
> > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > Subject: RE: Table statistics
> >
> >
> > Try:
> >
> > <?
> > mysql_connect("localhost", "user", "password");
>
> ...
>
> Might be helpful to the original poster to mention that this is Perl. He
> didn't specify a language, so he may not comprehend what you've offered.
This is actually PHP which I use a lot myself. But I wanted to know if
there was a simple command for this within mysql, or some option to
mysqlshow. It's far quicker to type somethinmg on the command line than
fire up a web browser, etc. And there must be a lot of MySQL installations
on servers which aren't also web servers, or don't have PHP installed,
etc.
Actually, it would be very nice if MySQL had a shell API - you can do this
to some extent by piping a command file into it but it involves a fair
amount of work to get the same functionality you get with, say, the C or
PHP interfaces.
> I don't mean this as a criticism, but it's interesting that we seem to often
> assume that Perl is THE language for scripting MySQL. Not true, of course.
> In fact, I'm finding Python easier, except for the blasted printf type
> formatting, whose syntax was driving me batty yesterday until... well, I
> could go on, but I won't.
Try PHP?
;-)
cheers,
Andy
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
