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

[expired user #4216]'s profile image [expired user #4216] posted 15 years ago in General Permalink
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?
[expired user #4216]'s profile image [expired user #4216] posted 15 years ago Permalink
Hi again
I found the answer, thanks - so need for a response. In case anybody else is struggling it's in the defaults column.
[expired user #1125]'s profile image [expired user #1125] posted 15 years ago Permalink
cool, thanks for the update

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