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

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.


For other users who might be in the same situation… Use the VARCHAR with the database and then initial value as UNIQUEID() in the app. When you have the initial value, you can hide that field.

1 Like