Thanks for the site...it answered my question, actually.
I was not aware that an auto_increment must be not null. And am I correct
that when it says it must be a "key", it means that it must be either
Primary or Unique?
That I did not know.
Anyway, it's working now :)
--
Plutarck
Should be working on something...
...but forgot what it was.
""Jason Lotito"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
>
> > -----Original Message-----
> > From: Plutarck [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, April 06, 2001 10:35 PM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP] AUTO_INCREMENT with MySQL & phpmyadmin
> >
> >
> > At first I thought this might be better suited on the mysql list,
> > but since
> > I'm using phpmyadmin I thought it better to ask here.
> >
> > My problem is I can't figure out how to create a column with the
> > auto_increment attribute. I want to make one called userid whose value
is
> > one higher than the highest number in the userid column, which
> > according to
> > the manual is exactly what auto_increment should do.
> >
> > But I flat out can't figure out how to do it.
> >
> > I'm using the "add new field" attribute in phpmyadmin, and I've
> > tried making
> > one with no name and with many different names, and I don't get nuttin'.
> >
> > Occassionally it will announce that the table was altered with something
> > like the message:
> >
> > SQL-query:
> > ALTER TABLE test_kingdoms_userauth ADD useridi TINYINT not null
> > AUTO_INCREMENT
> >
> > But according to the display, no matter how many times I refresh it,
there
> > is no listing of ANY column other than the two I currently have.
> >
> > So I'm totally confused, and out of the whole mysql manual I just
> > don't know
> > what's wrong.
> >
> >
> > So the question:
> >
> > What kind of selections do I need to make to create an AUTO_INCREMENT
> > column?
> >
>
>
> Can you post the current schema (design) of the table with datatypes, etc.
>
> http://www.newbienetwork.net/sections.php?op=viewarticle&artid=10
>
> Also, check out the above link, that my help some.
>
> Jason Lotito
> www.NewbieNetwork.net
> Where those who can, teach;
> and those who can, learn.
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
