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?
--
Plutarck
Should be working on something...
...but forgot what it was.
--
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]
