image

image

his chapter introduces you to the basics of writing stored programs in MySQL. MySQL 5.0 and forward provide stored programs in the SQL/PSM (SQL/Persistent Stored Module) engine. SQL/PSM is a procedural language (or imperative language as qualified in Chapter 1). SQL/PSM allows you to write blocks of code that contain transactional units.

Chapter 4 introduced transactional units, which are a set of INSERT, UPDATE, and DELETE statements bundled within Transaction Control Language (TCL) statements. The TCL statements let you bookmark where your ...

Get Oracle Database 11g & MySQL 5.6 Developer Handbook 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.