Using generated columns

A generated column allows you to store data in a column based on an expression. Generated columns can be useful when you want to store something in a table based on other columns. For example, if you wanted to have the batting average stored, you would need to divide other fields in the batting table to do this. Generated columns can be helpful instead of having to calculate a value every time you execute a query. With a generated column, you will just put the generated column name in the query instead of having to calculate on the fly.

Types of generated columns

A generated column can either be virtual or stored. You can store a mix of virtual and stored columns in a table. Generated columns can...