What is 'comments' field in MySQL phpMyAdmin when creating a table?

Question

I have wondered this for many years and every time I did a search it was totally unrelated to what I am looking for as it thought I was searching for "how to comment out data". When you create a new DB table in phpmyadmin, there is a comments field there. What the heck is that for? :) I assumed it allowed you to leave notes on that field or something, but I tried to enter data in that field once and look around that table and didn't see anything. Please let me know what its purpose is. Thank you :)

Answer 1

Its simply just a comment so if you need to go back to that column and remember why/how you created it, you can reference it.

For Example: storeHeadID : int, comment: "This is the ID of the store's head office"

Answer 2

Once you added a comment in the comment field for a column, you should see a dotted underline under that column name in the table's structure view. If you mouse-over that underline you will see your comment as a tooltip. It is very handy to keep track of what the different values in the column mean eg. "status 0:disabled, 1:active, 2:suspended etc."