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
-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
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 it
-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
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 necessary
-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;
No.