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
