Re: select in Mysql 4.0 - Michael Stassen - com.mysql.lists.mysql

5 messages in com.mysql.lists.mysqlRe: select in Mysql 4.0

From	Sent On	Attachments
fgmmoribe	26 Jul 2004 18:54
Michael Stassen	26 Jul 2004 22:11
Jocelyn Fournier	26 Jul 2004 23:45
SGr...@unimin.com	27 Jul 2004 05:54
Michael Stassen	27 Jul 2004 08:14

Subject:	Re: select in Mysql 4.0
From:	Michael Stassen (Mich...@verizon.net)
Date:	07/27/2004 08:14:06 AM
List:	com.mysql.lists.mysql

You're absolutely right, date is not a reserved word. Don't know what I was thinking.

Michael

Jocelyn Fournier wrote:

Hi,

AFAIK, date is *not* a reserved keyword, not need to backtick it :)

----- Original Message ----- From: "Michael Stassen" <Mich...@verizon.net> To: "fgmmoribe" <fgmm...@terra.com.br> Cc: "mysql" <mys...@lists.mysql.com> Sent: Tuesday, July 27, 2004 7:11 AM Subject: Re: select in Mysql 4.0

fgmmoribe wrote:

I have a table like this

+-------------+-------------------+------+-----+---------+----------------+

+-------------+-------------------+------+-----+---------+----------------+

| id | int(3) | | PRI | NULL |

auto_increment |

+-------------+-------------------+------+-----+---------+----------------+

Is there anyway to make select command like this in Mysql 4.0: select * from #temp where cod in (select max(cod) from #temp group by idtable) order by data desc

could someone help me?

thanks

Fernando

Subqueries require mysql 4.1.

date is a reserved word, so not the best choice for a column name. You'll always have to quote it with backticks to use it.

Your query doesn't seem to match your table.

That said, I think you want <http://dev.mysql.com/doc/mysql/en/example-Maximum-column-group-row.html>.