I install MySQL on Linux 2.6.9-52bs #2 x86_64 x86_64 x86_64 GNU/Linux, 16G
memory with followiing step: 1. ./configure --prefix=/home/mysql/mysql2. make3.
make install I set innodb_pool_buffer_size = 8G in my.cnf, but when I use "show
variables like 'innodb_buffer_pool_size';" the result is :
+
How it works...
"KEVIN ZEMBOWER" <[EMAIL PROTECTED]> wrote on 11/04/2005 12:40:50 PM:
> Man, you're awesome. Only two typos in the whole procedure. However,
> for the life of me, I'm puzzled over how it works. If you have more
> patience can you explain?
>
> Correct query (table is singular, no
Man, you're awesome. Only two typos in the whole procedure. However, for the
life of me, I'm puzzled over how it works. If you have more patience can you
explain?
Correct query (table is singular, not PHPAUCTIONS_...):
CREATE TEMPORARY TABLE tmpWinners SELECT auction, max(bid) as winningbid
FRO
Shawn, thank you for your complete answer. I'm still working through your first
post. I apologize for not noticing this FAQ. I didn't take it into account
because I thought it only applied to MySQL 5 and I'm using 4.0.24.
Thanks, again. I'll be in touch regarding your first post as I work with y
[EMAIL PROTECTED] wrote on 11/04/2005 11:22:35 AM:
> This is such a FAQ that they put the answer in the manual:
> http://dev.mysql.com/doc/refman/5.0/en/index.html
>
OOPS! I copied the wrong link. It should have been:
http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html
"KEVIN ZEMBOWER" <[EMAIL PROTECTED]> wrote on 11/04/2005 11:05:05 AM:
> My organization runs an online auction on our intranet server for
> the United Way. I'm having a hard time printing out a list of the
> winning bidders (I'm under a lot of pressure; the baked goods are
> getting stale).
>
My organization runs an online auction on our intranet server for the United
Way. I'm having a hard time printing out a list of the winning bidders (I'm
under a lot of pressure; the baked goods are getting stale).
In these examples, I've just printed out my bidder's first names, to protect
thei
age -
> From: "Mauricio Pellegrini" <[EMAIL PROTECTED]>
> To: "MySql List"
> Sent: Tuesday, April 12, 2005 7:35 PM
> Subject: How to select the max value
>
>
> > Hi,
> > I need to select the max value from a set of records but I also need
Daniel Kasak wrote:
>Mauricio Pellegrini wrote:
>
>
>
>>Hi,
>>I need to select the max value from a set of records but I also need the
>>primary key for that record.
>>
>>The problem is that the record id may not be the same as the record max
>>
Rhino
- Original Message -
From: "Mauricio Pellegrini" <[EMAIL PROTECTED]>
To: "MySql List"
Sent: Tuesday, April 12, 2005 7:35 PM
Subject: How to select the max value
> Hi,
> I need to select the max value from a set of records but I also need the
&
Mauricio Pellegrini wrote:
>Hi,
>I need to select the max value from a set of records but I also need the
>primary key for that record.
>
>The problem is that the record id may not be the same as the record max
>value for the column as in the following example:
>
>
Hi,
I need to select the max value from a set of records but I also need the
primary key for that record.
The problem is that the record id may not be the same as the record max
value for the column as in the following example:
Table_x
Id x_col date_col
1 1 2005-04-11
2
jim wrote:
One solution would be to use a variable:
SELECT @latest:= MAX(dateCreated);
Here I am getting the errors:
mysql> SELECT @latest:= MAX(dateCreated);
ERROR 1054: Unknown column 'dateCreated' in 'field list'
mysql> SELECT @latest:= MAX(user.dateCreated);
ERROR 1109: Unknown table 'use
> jim wrote:
>
> > Hi,
> >
> > The task is to find users whose accounts have not been validated for the
> > last 10 days. This SELECT accomplishes that:
> >
> > SELECT * FROM user WHERE validated LIKE 'N' AND dateCreated <=
> > DATE_SUB(CURDATE(), INTERVAL 10 DAY)
> >
> > But, using curdate()
jim wrote:
Hi,
The task is to find users whose accounts have not been validated for the
last 10 days. This SELECT accomplishes that:
SELECT * FROM user WHERE validated LIKE 'N' AND dateCreated <=
DATE_SUB(CURDATE(), INTERVAL 10 DAY)
But, using curdate() is dangerous. What if the system time is
Hi,
The task is to find users whose accounts have not been validated for the
last 10 days. This SELECT accomplishes that:
SELECT * FROM user WHERE validated LIKE 'N' AND dateCreated <=
DATE_SUB(CURDATE(), INTERVAL 10 DAY)
But, using curdate() is dangerous. What if the system time is messed
up?
Vikram Vaswani <[EMAIL PROTECTED]> wrote:
>
> Is there a way to update the record with maximum value in a table with
> another value?
>
> I am trying this:
>
> mysql> update services set sfee = 1 where sfee = max(sfee);
> Query OK, 0 rows affected (0.06 sec)
> Rows matched: 0 Changed: 0 Warnin
Hi all,
Is there a way to update the record with maximum value in a table with
another value?
I am trying this:
mysql> update services set sfee = 1 where sfee = max(sfee);
Query OK, 0 rows affected (0.06 sec)
Rows matched: 0 Changed: 0 Warnings: 0
But it doesn't make any changes to the data.
Slish, nu ti I nazvalsia, Egor Egorov, eshe bi Vasey Pupkinim
nazvalsia-bi hahahahahaha ;-)
Best Regards, Anton
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 9:38 AM
To: [EMAIL PROTECTED]
Subject: re: Selecting max value from sets
he table
> Don4 //Don't highest value in the table
>
> So I'm looking for distinct maximums.
> Is it possible to do this *with a single query* in MySQL? I've tried a
> number of things and nothing comes close.
SELECT Name, MAX(Value) FROM Value_Pairs GRO
On Thu, 2003-01-09 at 22:06, Benjamin Dixon wrote:
>
> Hi all,
>
> I'm trying to figure out a way to select a group of maximums from a set
> such that each value pair's greatest value is in the result set. For
> example, let's say I have this table Value_Pairs:
>
> Name | Value
>
>
Hi all,
I'm trying to figure out a way to select a group of maximums from a set
such that each value pair's greatest value is in the result set. For
example, let's say I have this table Value_Pairs:
Name | Value
Bob1
Joe7
Bob2
Don3
Don4
Bob6
The result I wan
Bill,
Wednesday, October 09, 2002, 6:55:26 PM, you wrote:
BH> Nope - nothing close to 4GB or even 1GB... My greatest data file size
BH> is 80MB. The largest table is 1.7 million rows. I have databases with
BH> more and bigger files. I think my problem is that the table having the
BH> proble
On 9 Oct 2002, at 11:55, Bill Hess wrote:
> One would think that the value would not top out until 2^31
> since I have it defined as a normal INT. I guess I can make it a
> BIGINT, but I think I will run into a problem eventually
> regardless how big I make the field...
Since the limit you're h
"Keith C. Ivey" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, October 08, 2002 4:52 PM
> Subject: Re: AUTO_INCREMENT max value...
>
>
>
>>Not really getting errors but getting warnings when inserting
>
> records
>
>>
, October 08, 2002 4:52 PM
Subject: Re: AUTO_INCREMENT max value...
> Not really getting errors but getting warnings when inserting
records
> and having duplicate values since the primary key is the one that is
> auto incremented...
>
> Keith C. Ivey wrote:
> > On 8 Oct 2002, at 12:23
Bill Hess wrote:
> Hello all...
>
> What is the maximum value of an AUTO_INCREMENT field? I am currently
> running into a maximum value of 296,995,724 on Solaris 8 using MySQL
> 3.23.42 - the field has been defined as an INT(11), which should be able
> to handle a value bigger than what I am see
Not really getting errors but getting warnings when inserting records
and having duplicate values since the primary key is the one that is
auto incremented...
Keith C. Ivey wrote:
> On 8 Oct 2002, at 12:23, Bill Hess wrote:
>
>
>>What is the maximum value of an AUTO_INCREMENT field? I am cur
Did you try unsigned int?
Bill Hess wrote:
> Hello all...
>
> What is the maximum value of an AUTO_INCREMENT field? I am currently
> running into a maximum value of 296,995,724 on Solaris 8 using MySQL
> 3.23.42 - the field has been defined as an INT(11), which should be
> able to handle a v
On 8 Oct 2002, at 12:23, Bill Hess wrote:
> What is the maximum value of an AUTO_INCREMENT field? I am currently
> running into a maximum value of 296,995,724 on Solaris 8 using MySQL
> 3.23.42 - the field has been defined as an INT(11), which should be able
> to handle a value bigger than wh
Hello all...
What is the maximum value of an AUTO_INCREMENT field? I am currently
running into a maximum value of 296,995,724 on Solaris 8 using MySQL
3.23.42 - the field has been defined as an INT(11), which should be able
to handle a value bigger than what I am seeing - The DuBois MySQL boo
At 16:30 -0400 5/9/02, Andrew Kuebler wrote:
> I want to select say 100 of 1,000 records and get the highest value for
> "id" in that query, however the MAX command always gives me the MAX for
> the whole table, not just my query.
>
> Here's my expression:
> SELECT MAX(id) FROM table WHERE DATE =
At 16:30 -0400 5/9/02, Andrew Kuebler wrote:
>I want to select say 100 of 1,000 records and get the highest value for
>"id" in that query, however the MAX command always gives me the MAX for
>the whole table, not just my query.
>
>Here's my expression:
>
>SELECT MAX(id) FROM table WHERE DATE = '20
al Message-
From: Andrew Kuebler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 4:31 PM
To: [EMAIL PROTECTED]
Subject: Pretty Simple MAX Value question...
I want to select say 100 of 1,000 records and get the highest value for
"id" in that query, however the MAX command always
SELECT MAX(id)
FROM (SELECT MAX(id)
FROM table
WHERE DATE = '20020509'
LIMIT 100)
Dunno if this works in MySQL, I can't access a MySQL database from here to
test it out.
This should return the value that you want but I would be interested to
learn the usefulness of runni
I want to select say 100 of 1,000 records and get the highest value for
"id" in that query, however the MAX command always gives me the MAX for
the whole table, not just my query.
Here's my expression:
SELECT MAX(id) FROM table WHERE DATE = '20020509' LIMIT 100
No matter what, I will always get
Hi.
This is the documented behaviour. For details, see
http://www.mysql.com/doc/G/r/Group_by_functions.html
How to deal with this is discussed in the tutorial section:
http://www.mysql.com/doc/e/x/example-Maximum-column-group-row.html
Bye,
Benjamin.
On Sat, Mar 30, 2002 at 09:24:26PM
Everyone,
Is this a bug or somethingi am using the latest version of MySQL server
and it works fine and convincing...but I observe that if I use the MAX()
functioni got this
I include max() function to my select query
Ex..
select max(A),B,C from table_name group by A;
the result i
From: Mike Yuen <[EMAIL PROTECTED]>
> The query I have is: select max(mid) from mboard;
> BUT I tried the following in PHP and it doesn't work:
>
> $myquery = "SELECT max(mid) FROM mboard";
> $myresult = mysql_query($myquery);
> $row = mysql_fetch_object($myresult);
> print "$row->mid is result
I have a table as such where mid is my auto increment primary key:
TABLE: mboard
mid
2
3
4
5
I'm doing this in combination with PHP4.
What I want to do is build a query that will allow me to get the largest mid
from the table (mboard) above.
The query I have is: select max(mid) from mboard;
BUT
Hi,
> SELECT max(fieldname) FROM table;
I think with this you get the CURRENT max value of entries existing in
the table, but not the REALLY maximum value you are able to insert.
> > Does anybody knows how can I check whether the max value in some
> > database's
> >
SELECT max(fieldname) FROM table;
> Hi!
>
> Does anybody knows how can I check whether the max value in some
> database's
> field has
> been reached?
> For example, I have MEDIUMINT column and I want to reset its value once it
> reaches its maximum, that is 8388607.
Hi!
Does anybody knows how can I check whether the max value in some database's
field has
been reached?
For example, I have MEDIUMINT column and I want to reset its value once it
reaches its maximum, that is 8388607. How can I check which is the maximum
(min) value I can insert into field?
Bye!
Hi !
is there any way to do this ?
SELECT T2.monedaID, T2.fecha, T1.descripcion, T2.compra, T2.venta FROM UYMonedasBCU
T1, UYMonedasCotizaInter T2
WHERE
(T2.fecha = (SELECT DISTINCT MAX (T3.fecha )FROM
uymonedascotizainter T3 )) AND (T1.forma = 'Billete') AND (T2.monedaID = T1.id )
The matt
age-
> > From: Roman Arefiev [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, February 02, 2001 10:25 AM
> > To: [EMAIL PROTECTED]
> > Subject: Max value
> >
> >
> > Hello, I'm a newbie in MySql, it would be great if you can help me ..
> > the
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Gro
up_by_functions
max(x) works with the group by clause.
> -Original Message-
> From: Roman Arefiev [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 02, 2001 10:25 AM
> To: [EMAIL PROTECTED]
&g
Hello, I'm a newbie in MySql, it would be great if you can help me ..
the problem is :
I have a Mysql table like:
create table users (user varchar(20), debt int(10));
How can I select user with the greatest value of debt ?
I have this function (max) in MS Access database and it works perfectly.
47 matches
Mail list logo
