Autoincrement feature with MySQL?

I am converting from MS Access to MySQL. Does anyone know how do you get the autoincrement feature with MySQL With MS Access that seemed to happen automatically with the "INSERT INTO" function. "INSERT INTO" gives a "Duplicate entry" with MySQL. Thanks, Nick

Create the table as follows: CREATE TABLE my_table (     id int(6) NOT NULL auto_increment, ) What interface/client are you using for mysql? if you can install something that runs on PHP, I recomend http://www.phpmyadmin.net/home_page/ I know it is PHP and I shall be shunned upon by the list, but it is a great way to manage mySQL db's I hope that helps > Does anyone know how do you get the autoincrement feature with MySQL -- Mark Drew http://cybersonic.blogspot.com mailto:mark.drew@gmail.com

I'm pretty sure someone on this list has created a "CFMyAdmin" program... Create the table as follows: CREATE TABLE my_table (     id int(6) NOT NULL auto_increment, ) What interface/client are you using for mysql? if you can install something that runs on PHP, I recomend http://www.phpmyadmin.net/home_page/ I know it is PHP and I shall be shunned upon by the list, but it is a great way to manage mySQL db's I hope that helps > Does anyone know how do you get the autoincrement feature with MySQL -- Mark Drew http://cybersonic.blogspot.com mailto:mark.drew@gmail.com   _____  

And it would have been really nice of me to take a half-second to look that up before I hit send...sorry: http://www.cfmyadmin.com/ <http://www.cfmyadmin.com/>; I'm pretty sure someone on this list has created a "CFMyAdmin" program... Create the table as follows: CREATE TABLE my_table (     id int(6) NOT NULL auto_increment, ) What interface/client are you using for mysql? if you can install something that runs on PHP, I recomend http://www.phpmyadmin.net/home_page/ I know it is PHP and I shall be shunned upon by the list, but it is a great way to manage mySQL db's I hope that helps > Does anyone know how do you get the autoincrement feature with MySQL -- Mark Drew http://cybersonic.blogspot.com mailto:mark.drew@gmail.com   _____   _____  

Hi there! Thanks for that, I shall check it out! I just wanted to mention that I use the phpmysqladmin a lot .. will let you know what I think of the CF version :) > http://www.cfmyadmin.com/ <http://www.cfmyadmin.com/>; -- Mark Drew http://cybersonic.blogspot.com mailto:mark.drew@gmail.com

RE: CFMYADMIN I had a quick check and install (how quick was that?!!) only thing that it has missing which I LOVE in phpmyadmin is the ability to export (to XML, CSV, SQL including Structure and/or Data) But that is now off topic (and my last 2 cents/pennies) -- Mark Drew http://cybersonic.blogspot.com mailto:mark.drew@gmail.com