Ahhh...I see

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"" <Jason@LehighWeb.com> wrote in message news:JGECJMDPBKLDPBIJBAJDGELNCCAA.Jason@LehighWeb.com... > > > > -----Original Message----- > > From: Plutarck [mailto:aemuli@spamclause-yahoo.com] > > Sent: Friday, April 06, 2001 10:35 PM > > To: php-general@lists.php.net > > 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: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >