>IMHO, The Right Thing to do this, is to create the additional data in
>your application (as you said you won't change the table).
(...)
thank you!
>If you want this with SQL for sure, using user-defined variables will
>work:
cool. sorry, but I'm still learning, since I'm into MySQL from a few time
only!
>mysql> select @a := @a + 1 AS pos, gid from config where gid>300000 limit 10;
>+------+--------+
>| pos | gid |
>+------+--------+
>| 1 | 300001 |
>| 2 | 300002 |
>| 3 | 300003 |
...can I use the "pos" data in a "WHERE" statment?
something like..
select @a := @a + 1 AS pos, gid from config where pos > 100 and pos <200 ?
(or there is a better way to have a particular subset of data WITHOUT
HAVING ANY INFO ON THE DB STRUCTURE?! I'm trying to have a tool to paging
the query result in a gui structure)
>Another approach would be to select the data into a TEMPORARY TABLE.
how can I do that?
thank you very much again!
bye bye!
MAS!
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
