-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Saturday 19 July 2003 19:20, Jim McAtee wrote:
> Interesting. In the case where you want to begin numbering existing rows
> at 1,
>
> is it necessary to set the autoincrement number to that of the next, i.e:
> > Alter Table X Auto_Increment = 201;
Michael Satterwhite wrote:
> > Are you saying that it will propogate through the _existing_ rows, or only
> > on rows added later?
>
> It will number all existing rows and continue with rows added later.
Interesting. In the case where you want to begin numbering existing rows at 1,
is it necess
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Saturday 19 July 2003 18:17, Jim McAtee wrote:
> Are you saying that it will propogate through the _existing_ rows, or only
> on rows added later?
It will number all existing rows and continue with rows added later.
- ---Michael
-BEGIN PGP SI
Michael Satterwhite wrote:
>> So I can add the column, and I can set it to have an auto_increment, but
>> will that start out at 201? or will it start at 1 and propogate through?
>
> If you don't modify the table definition, it will start at 1 and propagate
> throughout: e.g.
Are you saying that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Saturday 19 July 2003 17:17, Andrew Rothwell wrote:
> So I can add the column, and I can set it to have an auto_increment, but
> will that start out at 201? or will it start at 1 and propogate through?
If you don't modify the table definition, it
Good day list,
I hope that this is an easy one for you guys to help me with, I am
relatively new to DB design, and I realized that I have left out a few
very important Indexing and counting columns.
So my question is this,
What do I need to do to fill in new column, I would like to have it
au
