Is this possible?

[rel2007]

Hi,

I'm experimenting a bit with my codes to minimize the number of table that I'll be using.

Do you think this mysql row manipulation is possible?

Scenario:

1 table w/ 28 rows (maximum rows), with only rows from 1-20 filled, rows 21-28
only filled with the unique key for rows, ex: r21 or 21 and so on.....

I'd like to drop or demote the item in row #1 to row #21 (if row #21 is filled it will automatically drop or take the next empty field) to empty it so I can select another item from a selection list to take the #1 row position. This will be triggered by a drop button for each row from row #1-20.

Is this possible? Pls help!

Thanks!

[leatherback]

1) What you are explaining will not reduce the number of tables.

2) It is possible, but completely defeats the idea behind unique row numbers. Your post suggests that your ID column is not used by any other tables (Otherwise you would have to updat the other tables too), in which case you would not really need an ID column.

3) If you DO have dependencies between tables, do not mess with the IDs. Unless you are running a database with a huge daily turnover, you will not easily run out of keys.