Try this:
SELECT AVG((5+8+10)/3) AS rate FROM an_existing_table_name;
- Original Message -
From: "Mike Blezien" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Thursday, May 19, 2005 9:24 AM
Subject: Using AVG
Hello,
when using the AVG function like this:
SELECT AVG((5+8+10)/3) AS rate;
it r
- Original Message -
From: "Neculai Macarie" <[EMAIL PROTECTED]>
To: "Mysql"
Sent: Thursday, May 12, 2005 1:20 PM
Subject: Re: Maximum number of user variables
Not that I'm aware of. What type of conversions are you doing that you
need 30,000 use vars? An easy solution would be to try i
My company use it :)
PT. Tempo Inti Media Tbk
For experience sharing, contact me in private.
I believe there're alot of company here using MySQL.
Just take a look around.
"Me fail English? That's unpossible"
###___Archon___###
- Original Message -
From: "Leo" <[EMAIL PROTECTED]>
To: <
Assume you leave the default connect-retry to 60 secs.
Is the replication still stopped in the next 60 secs
after that?
"Me fail English? That's unpossible"
###___Archon___###
- Original Message -
From: "trashMan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 24, 2003 3
dd indexes again one by one , seems to be quicker for me especially
> for fulltext indexes , doing it at once tends to be slower, must crunch
the
> cpu a bit dont know
>
> > On Wed, Jul 09, 2003 at 11:51:01PM -0500, Paul DuBois wrote:
> >> At 14:14 +0700 7/9/03, Dominicus Donny w
Im thinking of using OpenMOSIX for that
kind of clustering (load balancing and shared
filesystem/storage).
But it doesn't support application that uses shared memory.
That's including Oracle, MySQL, etc...
But the shared storage feature gonna be useful for
our hundred gigs of images :)
"Me fail En
Specify other account(s)?
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
etc...
"Me fail English? That's unpossible"
###___Archon___###
- Original Message -
From: "P Srinivasulu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, July 10, 2003 2:40 PM
e table/db also located on another drive/partition.
"Me fail English? That's unpossible"
###___Archon___###
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Dominicus Donny" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednes
Try analyze your table(s).
"Me fail English? That's unpossible"
###___Archon___###
- Original Message -
From: "electroteque" <[EMAIL PROTECTED]>
To: "Paul DuBois" <[EMAIL PROTECTED]>; "Florian Weimer" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, July 09, 2003 10:23 AM
Subject
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 08, 2003 7:58 PM
Subject: Re: Replication stops for no reason...
> "Jeff McKeon" <[EMAIL PROTECTED]> wrote:
> > I've seen one other reference to this exact situation but it didn't have
SELECT * FROM tablename LIMIT 5, 6
"Me fail English? That's unpossible"
###___Archon___###
- Original Message -
From: "Nils Valentin" <[EMAIL PROTECTED]>
To: "Maciej Bobrowski" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, July 02, 2003 4:47 PM
Subject: Re: specific records
If it is the replication problem...::
Check the replication account on the master server:
...[EMAIL PROTECTED] identified by ...
...[EMAIL PROTECTED] identified by ...
...[EMAIL PROTECTED] identified by ...
...
...[EMAIL PROTECTED] identified by ...
or perhaps simply set to
...
LIMIT 1
"Me fail English? That's unpossible"
###___Archon___###
- Original Message -
From: <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Friday, June 27, 2003 12:08 PM
Subject: SELECT single record
> Thanks everybody for all you great help!
>
> Ok, this statement will s
13 matches
Mail list logo
