RE: [PHP] AUTO_INCREMENT with MySQL & phpmyadmin

> -----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.