MySQL Forums
Forum List  »  German

Re: SELECT MAX() problem
Posted by: Thomas Wiedmann
Date: September 12, 2012 12:09PM

Hallo Lars,

stimmt, jetzt fällt mir noch auf, die Spaltennamen

- type
- values

sind reservierte Worte von MySQL. Wenn möglich keine reservierten Worte als Spaltennamen werden. Die Notlösung sind die sogenannten Backticks.

CREATE TABLE serverlist (
 ip INT NOT NULL,
 port INT NOT NULL,
 timestamp DATETIME NOT NULL,
 `type` INT NOT NULL,
 `values` INT NOT NULL
);


SELECT ip,
       port,
       MAX(timestamp) AS timestamp,
       MAX(`type`) AS mytype,
       MAX(`values`) AS myvalues
  FROM serverlist
GROUP BY ip, port;
Empty set (0.00 sec)

mysql>

Was ich zu ONLY_FULL_GROUP_BY gesagt habe, stimmt aber ebenso.

Grüße
Thomas



Edited 2 time(s). Last edit at 09/12/2012 12:10PM by Thomas Wiedmann.

Options: ReplyQuote


Subject
Views
Written By
Posted
2145
September 12, 2012 07:59AM
1220
September 12, 2012 08:50AM
915
September 12, 2012 09:39AM
892
September 19, 2012 04:12AM
989
September 12, 2012 09:45AM
Re: SELECT MAX() problem
1369
September 12, 2012 12:09PM
941
September 12, 2012 12:27PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.