MySQL Generated Columns, Views, and Triggers
By Dave Stokes
Databases often have neat features that go unnoticed or lightly used that could make your life as a developer much easier. This article started its path to print at the php[tek] 2018 conference with a discussion on generated columns in MySQL. Several attendees seemed to need extra guidance and this article is an attempt to document how to use some underutilized features. These features do some of the work you would normally do in your application at the database layer which could save you a great deal of time, effort, and potential mistakes.
This article was originally published in the August 2018 issue of php[architect] magazine. To read the complete article please subscribe or purchase the complete issue.
Leave a comment
Use the form below to leave a comment: