|
|
Posted by J.O. Aho on 08/18/06 17:07
Flaming Corncob wrote:
> In article <4km59fFcpnbrU1@individual.net>,
> "J.O. Aho" <user@example.net> wrote:
>
>> Flaming Corncob wrote:
>>> Ok, I just don't understand it.. what are the practical uses of indexes,
>>> AUTO_INCREMENT etc.. how are they supposed to work?
>> The sql server will take care of the increment of the value, without you need
>> first check up whats the highest value, then add one to it and then insert
>> the
>> new data to the table. This can lead to that more than one will try to insert
>> data with the same value, which leads to problems.
>> With the auto increment, you don't need to insert the value when you insert
>> data into your table, it will automatically be inserted and adjusted, and no
>> risk for two to get the same value.
>>
>> This is useful when you want to give unique id-numbers for all rows in a
>> table.
> Sounds like what I already read.. just can't picture the practical use.
> Maybe because it's not what I'm looking for?
I don't know what you are looking for, but AUTO_INCREMENT is really useful for
row id's, if you don't use any row identification, then it's not useful for you.
//Aho
Navigation:
[Reply to this message]
|