Back to Vol 17, Issue 5

PHP Architect · Vol 17, Issue 5 · May 2018

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.

The full article is in PHP Architect Vol 17, Issue 5. Subscribe to read it and every new issue.

Subscribe
Dave Stokes

About the author

Dave Stokes

Dave Stokes started using PHP when it was known as Personal Home Page and started working for MySQL AN as a PHP Developer. He is now a MySQL Commmunity Manager for Oracle Corporation. He lives in Texas with the required hound dog and pickup truck.

Our Partners

Collaborating with industry leaders to bring you the best PHP resources and expertise

Interested in partnering? Get in touch →