Hiding a key linked to a AUTO_INCREMENT/IDENTITY MySQL database field

[indavidjool]

I was entering this as a question but found the answer as I was busy doing it, so I thought I’ll just leave a link here in case someone comes across the same difficulty.

I had difficulty hiding a field because it was a key field and I did not wish to set the initial value, thinking it would cause problems during an update. The linked document explains the issue satisfactorily.