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:[EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to