Hi, On Jan 18, 2008 3:50 AM, Moon's Father <[EMAIL PROTECTED]> wrote: > My test is as follows: > mysql> select g_id from t group by g_id order by g_id desc limit 0,1; > +------+ > | g_id | > +------+ > | 6 | > +------+ > 1 row in set (0.00 sec) > > mysql> select g_id from t group by g_id order by g_id desc limit 0,1 into > @tmp_id; > Query OK, 1 row affected (0.00 sec) > > mysql> select @tmp_id; > +---------+ > | @tmp_id | > +---------+ > | 5 | > +---------+
Try it this way: mysql> select @tmp_id := g_id from t group by g_id order by g_id desc limit 0,1; +-----------------+ | @tmp_id := g_id | +-----------------+ | 6 | +-----------------+ 1 row in set (0.00 sec) mysql> select @tmp_id; +---------+ | @tmp_id | +---------+ | 6 | +---------+ This seems like a bug to me. You should file a bug report at bugs.mysql.com. > 1 row in set (0.00 sec) > > mysql> select version(); > +-----------------+ > | version() | > +-----------------+ > | 5.1.21-beta-log | > +-----------------+ > 1 row in set (0.00 sec) > > mysql> > > > But the variabe @tmp_id 's value is 5; > Any help is appreciated. > > Here is my test data. > > DROP TABLE IF EXISTS `t`; > > CREATE TABLE `t` ( > `id` int(11) NOT NULL auto_increment, > `g_id` int(11) NOT NULL, > `t_str` varchar(255) NOT NULL, > PRIMARY KEY (`id`), > key (`g_id`) > ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8; > > /*Data for the table `t` */ > > insert into `t`(`id`,`g_id`,`t_str`) values > (1,2,'wo'), > (2,2,'ni'), > (3,2,'ta'), > (4,3,'wo '), > (5,4,'ni'), > (6,3,'ni'), > (7,4,'ta'), > (8,3,'wang'), > (9,4,'li'), > (10,3,'hai'), > (11,4,'ri'), > (12,2,'ren'), > (13,5,'ta'), > (14,6,'ri'), > (15,6,'ren'), > (16,6,'fuck'), > (17,6,'shit'), > (18,5,'ls'), > (19,5,'chmod'), > (20,5,'chgrp'), > (21,5,'chown'), > (22,3,'rm'), > (23,3,'desc'), > (24,4,'pwd'), > (25,5,'cd'); > > > -- > I'm a mysql DBA in china. > More about me just visit here: > http://yueliangdao0608.cublog.cn > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]