Michael
Jocelyn Fournier wrote:
Hi,
AFAIK, date is *not* a reserved keyword, not need to backtick it :)
Regards,
Jocelyn Fournier
www.presence-pc.com
----- Original Message ----- From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "fgmmoribe" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, July 27, 2004 7:11 AM
Subject: Re: select in Mysql 4.0
fgmmoribe wrote:
I have a table like this
+-------------+-------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+-------------+-------------------+------+-----+---------+----------------+
| id | int(3) | | PRI | NULL |
auto_increment |
| idTable | int(3) unsigned | | | 0 |
|
| title | varchar(150) | YES | | NULL |
|
| description | varchar(150) | YES | | NULL |
|
| date | datetime | YES | | NULL |
|
+-------------+-------------------+------+-----+---------+----------------+
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>.
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
