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 firstname.lastname@example.org.
You may notice that some examples end in
;: 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
setting to avoid errors when MySQL sees a
; in the
stored procedure and interprets that as the end of the
PROCEDURE statement. By default the MySQL Query Browser uses
$$ as that delimiter, which is why some examples end
$$ - because they were created in the query