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?