No you can't, but check out LIMIT.
Marco Stagno wrote:
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.
No you can't, but check out LIMIT.
Ops, but I did it! grin
Using a variable and a temporary table as Benjamin and Keith wrote in the
prev. messages
ciao ciao!
MAS!
--
I love MySQL :-)
-
Hi.
I need to have a cardinal number near each data, when I submit a query:
for example, if my table is:
+-+
| example |
+-+
| cat |
| dog |
| horse |
I'd like to have, with a select statement..
+-+---+
| example |
On 5 Jun 2002, at 22:03, Marco Stagno wrote:
and if I delete the 'dog' record...
+-+---+
| example | pos |
+-+---+
| cat | 1 |
| horse | 2 |
...
IMPORTANT NOTE: I can't add a (permanent) column with an
Hi.
On Wed 2002-06-05 at 22:03:59 +0200, [EMAIL PROTECTED] wrote:
Hi.
I need to have a cardinal number near each data, when I submit a query:
for example, if my table is:
+-+
| example |
+-+
| cat |
| dog |
| horse |
I'd
It's not clear from your description whether the numbers are
associated with the records in the table or with the records returned
I'm trying to choose a subset only of the select result...
(without having any informations about the db/data structure)
should be handling in whatever you're
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