distal-attribute
distal-attribute
distal-attribute
distal-attribute

Defining Auro-Increment for Primary keys (and other fields?)

User, date Message
Written by johnain
5 years ago
Category: General
7 posts since Tue, 08 Sep 09
I am a new boy and I am astonished at how comprehensive and useable Heidi is. I also appreciate that it is still under development. But After PhpMyAdmin and other tools it is like emerging from a swamp. happy

because I am new I an not always confident that I know when I find an issue whether it is an unavailable feature, a bug, or just me being a little slow!

I worked out the F2 for the Key type. But I am lost as to how to define Auto Increment. I stusk a 1 in the Auto-increment box in options, but that doesn't seem to apply to the Primary key, because when I did an export that field was not set to AutoIncrement in the Create SQL. Neither was their an AUTO INCREMENT=n in the final section of the CREATE statement.

Also, can I apply AutoIncrement to other columns? Not Neccessarily key ones? If so, how? (I'm not a MySQL genius?)

Is it me? Or do I need to export, update the SQL and then Re-import?
Written by johnain
5 years ago
7 posts since Tue, 08 Sep 09
Hi again
I found the answer, thanks - so need for a response. In case anybody else is struggling it's in the defaults column.
Written by rosenfield
5 years ago
127 posts since Wed, 24 Jan 07
cool, thanks for the update
 

Please login to leave a reply, or register at first.