This is correct.Thank you very much. But I also why I wrote is wrong on linux and right on windows. You can tell me answer if you have time.thanks.
On Jan 19, 2008 12:47 AM, Baron Schwartz <[EMAIL PROTECTED]> wrote: > 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 > > > -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn