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:
> > M
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 orde
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
