RE: [sqlite] Unique ids for each record

2007-08-28 Thread Sreedhar.a
that I can do the search fast. Best Regards, Sreedhar. -Original Message- From: Dwight Ingersoll [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 21, 2007 11:43 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Unique ids for each record On 8/20/07, Sreedhar.a <[EMAIL PROTECTED]>

Re: [sqlite] Unique ids for each record

2007-08-21 Thread Dwight Ingersoll
On 8/20/07, Sreedhar.a <[EMAIL PROTECTED]> wrote: <> > > I want to restrict the Artist range to 100 to 199 so that with the id > I can make my search fast and also I knew with unique id that I need to > search for the Artist alone. <> Considering the small range of data it appears you want to

Re: [sqlite] Unique ids for each record

2007-08-21 Thread John Elrick
Eric Bohlman wrote: Sreedhar.a wrote: SNIP You need artist identifiers to be unique (you could in fact use artist names, since copyright rules require that such names be unique). You also need album names to be unique, but only within artist groups (you're not going to have the *same* artis

Re: [sqlite] Unique ids for each record

2007-08-21 Thread Markus Hoenicka
Quoting Eric Bohlman <[EMAIL PROTECTED]>: (you're not going to have the *same* artist release two albums with the same name). You need track names to be unique within artists, but not Except for weird artists like Peter Gabriel. All solo albums released between 1977 and 1982 were self-titled

Re: [sqlite] Unique ids for each record

2007-08-21 Thread Eric Bohlman
Sreedhar.a wrote: Hi Lokesh, Thanks for your suggestions. My proble is assigning a unique record for each record in a table. The database table name MUSIC. I have 3 columns Artist Album and Tracks. Artist1 Album1 Track1 Artist2 Album2 Track2 Artist3 Album2 Track3 I need to assign a uniqu

RE: [sqlite] Unique ids for each record

2007-08-20 Thread Sreedhar.a
e I deleted 2 records that space > is freed only.i tried after doing vacuum also.Is there any other way > to insert. > > > > . The rowid is also not updated after doing vacuum.Is there any > other way to update.If I tried the same by creating a table with > INTEGE

Re: [sqlite] Unique ids for each record

2007-08-20 Thread Babu, Lokesh
gt; freed only.i tried after doing vacuum also.Is there any other way to > insert. > > > > . The rowid is also not updated after doing vacuum.Is there any > other way to update.If I tried the same by creating a table with INTEGER > alone at that time rowed is updating prope

RE: [sqlite] Unique ids for each record

2007-08-17 Thread Sreedhar.a
fter doing vacuum.Is there any other way to update.If I tried the same by creating a table with INTEGER alone at that time rowed is updating properly after "Vacuum Test". Can any one please clarify my doubts. Best Regards, A.Sreedhar. -----Original Message- From: Markus Hoenic

Re: [sqlite] Unique ids for each record

2007-08-16 Thread Markus Hoenicka
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