From the course: MySQL Advanced Topics (2019)
Unlock this course with a free trial
Join today to access over 22,500 courses taught by industry experts.
About stored routines in MySQL - MySQL Tutorial
From the course: MySQL Advanced Topics (2019)
About stored routines in MySQL
- [Instructor] A stored routine is a set of SQL statements that are stored on a database server and can be used by any client with permission to use them. This provides a number of benefits. Database operations are normalized, so various applications will operate uniformly, even when written in different languages and operating on different platforms. Stored routines are easy to maintain, because they're all in one place, rather than distributed among different applications. Traffic is reduced between the client and server, because data is processed on the server, and security is enhanced by allowing clients to run with reduced permissions, while still being able to perform necessary database operations. There are also some disadvantages. Migration to a different server platform can be difficult, as stored routines tend to use a lot of platform specific features and code. And stored routines may be difficult to debug and…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.