⚠️ This post links to an external website. ⚠️
Recently, I was exploring a Rails application when I noticed that the developers had marked database columns as having sensitive data via a table's column definition. Various databases support comments for columns, but here's MySQL's explanation of a column comment:
A comment for a column can be specified with the
COMMENToption, up to 1024 characters long. The comment is displayed by theSHOW CREATE TABLEandSHOW FULL COLUMNSstatements. It is also shown in theCOLUMN_COMMENTcolumn of the Information SchemaCOLUMNStable.
continue reading on laravel-news.com
If this post was enjoyable or useful for you, please share it! If you have comments, questions, or feedback, you can email my personal email. To get new posts, subscribe use the RSS feed.