Functions

Just like stored procedures, you can create stored functions. The main difference is functions should have a return value and they can be called in SELECT. Usually, stored functions are created to simplify complex calculations.

Get MySQL 8 Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.