I assume you'd rather want three separate tables (artist, album,
track) with an autoincrementing ID field per table. Your approach
would not allow users to own more than 100 albums.
regards,
Markus
Quoting "Sreedhar.a" <[EMAIL PROTECTED]>:
Hi,
I have a table with 3 columns.
Artist Album and tracks.
Can i fix a range of ids for each column
like 1-100 for Artist 101-200 for Album and 201-300 for tracks
So that I can have a unique number(id) for each record.
Will there be a problem while deleting and inserting the records?
Thanks and best regards,
A.Sreedhar.
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------