sday, April 04, 2002 12:31 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Table statistics
On Thursday, 4. April 2002 08:12, Doug Bishop wrote:
> mysql_connect("localhost", "user", "password");
> $query = "SHOW TABLES;&q
On Thu, 4 Apr 2002, Georg Richter wrote:
> On Thursday, 4. April 2002 10:42, andy thomas wrote:
>
> > Yes but this is PHP code that can only be run through a suitable web
> > server, browser, etc - I want a command line solution like mysqlshow ...
> > or from within the mysql client itself.
>
>
On Thu, 4 Apr 2002, denonymous wrote:
> From: "andy thomas" <[EMAIL PROTECTED]>
>
> > Is there a command I can give in the mysql client to find the number of
> > rows in a table or, better still, the number of rows in all the tables in
> > a database?
>
>
> To return the # of rows in a table:
>
On Thursday, 4. April 2002 10:42, andy thomas wrote:
> Yes but this is PHP code that can only be run through a suitable web
> server, browser, etc - I want a command line solution like mysqlshow ...
> or from within the mysql client itself.
You can also run PHP from the commandline without any w
* andy thomas
> Is there a command I can give in the mysql client to find the number of
> rows in a table or, better still, the number of rows in all the
> tables in a database?
The "normal" way: SELECT COUNT(*) FROM table
To get all tables in one statement... this is a hack, I'm not sure it wil
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
>
On Thu, 4 Apr 2002, Doug Bishop wrote:
> Try:
>
> mysql_connect("localhost", "user", "password");
> $query = "SHOW TABLES;";
> $result = mysql_db_query("databasename", $query);
> $i = 0;
> while ($row = mysql_fetch_array($result))
> {
> $tableNames[$i] = $row[0];
> $i++;
> }
> for ($
On Thursday, 4. April 2002 08:12, Doug Bishop wrote:
> mysql_connect("localhost", "user", "password");
> $query = "SHOW TABLES;";
> $result = mysql_db_query("databasename", $query);
> $i = 0;
> while ($row = mysql_fetch_array($result))
> {
> $tableNames[$i] = $row[0];
> $i++;
> }
> for
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
> >
> >
> &g
---
From: "Doug Bishop" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, April 04, 2002 1:12 PM
Subject: RE: Table statistics
> Try:
>
> mysql_connect("localhost", "user", "password");
> $query =
> -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
Try:
";
}
?>
Doug
-Original Message-
From: andy thomas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 11:23 PM
To: [EMAIL PROTECTED]
Subject: Table statistics
Is there a command I can give in the mysql client to find the number of
rows in a table or, better still, the numb
From: "andy thomas" <[EMAIL PROTECTED]>
> Is there a command I can give in the mysql client to find the number of
> rows in a table or, better still, the number of rows in all the tables in
> a database?
To return the # of rows in a table:
SELECT COUNT(*) FROM table_name;
Not sure about all ro
13 matches
Mail list logo
