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 | pos |
+-------------+-------+
| cat | 1 |
| dog | 2 |
| horse | 3 |
.... ...
and if I delete the 'dog' record...
+-------------+-------+
| example | pos |
+-------------+-------+
| cat | 1 |
| horse | 2 |
.... ...
IMPORTANT NOTE: I can't add a (permanent) column with an "auto_increment"
value; I'm writing a simple gui for mysql and I don't want to alter the
original db..
I'm using MySQL 3.23.49
can someone help me?
thank you in advance
regards.
Marco
---------------------------------------------------------------------
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
