O'Reilly logo

Oracle Database 11g & MySQL 5.6 Developer Handbook by Michael McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required