mNZQq9mQ

1CREATE TABLE IF NOT EXISTS `realtimedevicedata` (
2  `id` int(11) NOT NULL auto_increment,
3  `scenedevice_id` int(11) NOT NULL,
4  `module_id` int(11) NOT NULL,
5  `subid` tinyint(4) NOT NULL default '1',
6  `value` varchar(30) collate utf8_turkish_ci NOT NULL,
7  `timestamp` datetime NOT NULL,
8  PRIMARY KEY  (`id`),
9  KEY `scenedevice_id` (`scenedevice_id`),
10  KEY `module_id` (`module_id`),
11  KEY `timestamp` (`timestamp`)
12) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=2428598 ;
13	
14SELECT MAX(id)
15FROM table1
16	
17SELECT * FROM table1 WHERE id = MAX( id );
18	
19SELECT * FROM `table1` WHERE `id` = ( SELECT MAX(`id`) FROM `table1` )
20	
21SELECT a.*
22FROM   realtimedevicedata a
23JOIN   (SELECT MAX(id) AS id FROM realtimedevicedata) b ON a.id = b.id