MySQL Stored Procedure Programming

Using Code Examples

This book is here to help you get your job done. In general, you may use the code in this book in your programs and documentation. You do not need to contact us for permission unless you’re reproducing a significant portion of the code. For example, writing a program that uses several chunks of code from this book does not require permission. Selling or distributing a CD-ROM of examples from O’Reilly books does require permission. Answering a question by citing this book and quoting example code does not require permission. Incorporating a significant amount of example code from this book into your product’s documentation does require permission.

We appreciate, but do not require, attribution. An attribution usually includes the title, author, publisher, and ISBN. For example: "MySQL Stored Procedure Programming by Guy Harrison with Steven Feuerstein. Copyright 2006 O’Reilly Media, Inc., 0-596-10089-2.”

If you feel that your use of code examples falls outside fair use or the permission given here, feel free to contact us at [e-mail].

You may notice that some examples end in $$ rather than ;: this is because most stored program code is shown as it would appear in the MySQL Query Browser. When you create a stored procedure in most environments (including the MySQL query browser ) you need to change the DELIMITER setting to avoid errors when MySQL sees a ; in the stored procedure and interprets that as the end of the CREATE PROCEDURE statement. By default the MySQL Query Browser uses $$ as that delimiter, which is why some examples end in $$ - because they were created in the query browser.