Defining Auro-Increment for Primary keys (and other fields?)
| User, date | Message |
|---|---|
|
Written by johnain
4 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.  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
4 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
4 years ago 127 posts since Wed, 24 Jan 07 |
cool, thanks for the update |
|
Please login to leave a reply, or register at first. |