Re: [PHP] AUTO_INCREMENT with MySQL & phpmyadmin

I don't know why your query isn't working, but why aren't you using phpMyAdmin's add field section? Browse the tables definition page, and underneath the column descriptsion, is a line that says Add new fields [textbox: #][popup:At End of Database][button: Go] That brings up a fully functional c

RE: [PHP] AUTO_INCREMENT with MySQL & phpmyadmin

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

[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