MySQL Stored Procedure Programming covers a lot of ground. The book starts with a thorough introduction to stored procedures programming and functions, covering the fundamentals of data types, operators, and using SQL in stored procedures. You’ll learn how to build and maintain stored programs — covering transactions, stored functions, and triggers — and how to call and use MySQL-based stored procedures in a variety of languages, including PHP, Perl, Python, .NET, and Java. This book, destined to be the bible of stored procedure development, is a resource that no real MySQL programmer can afford to do without.

The implementation of stored procedures in MySQL 5.0 a huge milestone - one that is expected to lead to widespread enterprise adoption of the already extremely popular MySQL database. If you are serious about building the web-based database applications of the future, you need to get up to speed quickly on how stored procedures work — and how to build them the right way. This book, destined to be the bible of stored procedure development, is a resource that no real MySQL programmer can afford to do without.

In the decade since MySQL burst on the scene, it has become the dominant open source database, with capabilities and performance rivaling those of commercial RDBMS offerings like Oracle and SQL Server. Along with Linux and PHP, MySQL is at the heart of millions of applications. And now, with support for stored procedures, functions, and triggers in MySQL 5.0, MySQL offers the programming power needed for true enterprise use.

MySQL’s new procedural language has a straightforward syntax, making it easy to write simple programs. But it’s not so easy to write secure, easily maintained, high-performance, and bug-free programs. Few in the MySQL world have substantial experience yet with stored procedures, but Guy Harrison and Steven Feuerstein have decades of combined expertise.

Additional not by me (ganelon):
The examples are included in the following archives organized by chapter.  Each example is named according to the example in text (eg Ex01-01.sql is the text of example 01 in Chapter 01).  There are also some project files in Eclipse and Visual Studio format for the Java and .NET chapters.

TABLE OF CONTENT:
Chapter 01 - Introduction to MySQL Stored Programs
Chapter 02 - MySQL Stored Programming Tutorial
Chapter 03 - Language Fundamentals
Chapter 04 - Blocks, Conditional Statements, and Iterative Programming
Chapter 05 - Using SQL in Stored Programming
Chapter 06 - Error Handling
Chapter 07 - Creating and Maintaining Stored Programs
Chapter 08 - Transaction Management
Chapter 09 - MySQL Built-in Functions
Chapter 10 - Stored Functions
Chapter 11 - Triggers
Chapter 12 - Using MySQL Stored Programs in Applications
Chapter 13 - Using MySQL Stored Programs with PHP
Chapter 14 - Using MySQL Stored Programs with Java
Chapter 15 - Using MySQL Stored Programs with Perl
Chapter 16 - Using MySQL Stored Programs with Python
Chapter 17 - Using MySQL Stored Programs with .NET
Chapter 18 - Stored Program Security
Chapter 19 - Tuning Stored Programs and Their SQL
Chapter 20 - Basic SQL Tuning
Chapter 21 - Advanced SQL Tuning
Chapter 22 - Optimizing Stored Program Code
Chapter 23 - Best Practices in MySQL Stored Program Development

Microformats burst onto the scene a couple of years ago and are fast becoming an essential tool for all professional web designers and developers. Imagine being able to integrate all of your web-based contact details, tagged articles, and geographical information seamlessly in web and desktop applications, without having to add anything extra to your websites except a little specialized HTML markup. Microformats provide a more formalized technology for adding commonly used semantics (such as contact details, location, and reviews) to today’s Web. Unlike XML or the semantic Web, microformats use ubiquitous technologies like HTML and XHTML, existing developer skills, and current web tools, and, perhaps most important, they work in all of today’s web browsers. This book is a comprehensive guide to microformats. It explores why, in Bill Gates’s words, “We need microformats”; how microformats work; and the kinds of problems microformats help solve. the book covers every current microformat, with complete details of the syntax, semantics, and uses of each, along with real-world examples and a comprehensive survey of the tools available for working with them. the book also features case studies detailing how major web content publishers such as yahoo put microformats to work in their web applications. Written by one of the Web’s best-known educators, John Allsopp, Microformats: Empowering Your Markup for Web 2.0 will help you painlessly get up to speed with this exciting technology.

In this book you’ll learn

• How to take best advantage of the built-in semantics of XHTML and HTML
• How to extend the semantics of HTML using microformats and open up a world of new possibilities with web applications
• Every aspect of all the common microformats currently in use
• How microformats help your websites and applications easily integrate with web applications like Google Maps, as well as desktop applications like iCal, outlook, and entourage
• What innovative publishers and services, big and small, are doing right now with microformats

Textpattern is a powerful, PHP-based content management system that allows you to build pretty much any kind of data-driven website quickly and easily. It is very popular among designers and developers alike, and has an active community of users. Sound good? Well, you’re in luckthe book you’re holding now shows you how to use every aspect of Textpattern to a professional standard. Textpattern (and this book) appeals to two main groups of people: Firstly, the web designer who has mastered the fundamentals of XHTML and CSS and wants to create sites that have fresh and dynamically changing information, but is not familiar with server-side coding and databases. Never fear Textpattern enables you to integrate your XHTML knowledge, inserting dynamic aspects into your already solid site design. Secondly, PHP developers who are looking for a content management system upon which to build additional functionality and want a hand with the design aspects of their site. Again, Textpattern fills in those holes. The book leaves no stone unturned. It starts by introducing you to Textpattern and guiding you through its very simple installation process. After the core features of the administrative interface are explored, the book dives into building sites with TXP, using CSS, articles, forms, pages, and more to create fully customized templates. Development follows next, looking at installing plugins and building your own custom plugins to further enhance your Textpattern-based site. The book concludes with several case studies to provide ideas and inspiration, including a weblog, an e-commerce site, and an online review directory. 

In this book you will:

• Learn to develop websites quickly using Textpattern’s intuitive templating language.
• Learn to use Textpattern to build e-commerce websites, including customer feedback and reviews.
• Learn to use Textpattern and web standards to create blogs and community sites with dynamically driven content.
• Learn how to integrate your own style of coding and design with a content management system that catalyses, rather than hinders, your creativity.
• Learn how to use PHP to create Textpattern plugins, adding custom functionality and features to uniquely suit the needs of your website.

This book provides a complete application- and example-oriented introduction to the database system MySQL. No previous knowledge of SQL or database design is assumed.

MySQL is on the verge of repeating in the database market the success achieved by Linux in the operating system sector. In combination with PHP or Perl, MySQL is increasingly used as the database system for web sites. (A favorite combination is Linux + Apache + MySQL + Perl or PHP. Such systems are called “LAMP systems” for short.) MySQL is not just for small web sites; it is used by large firms with huge amounts of data, such as Yahoo!, Slashdot, and NASA.

The introductory part of the book begins with an extensive introduction on installing MySQL, Apache, PHP, and Perl under Windows and Linux. We also consider the installation of components that are used in combination with MySQL. Building on this, our first example will show the basic use of MySQL and PHP.

The second part of the book introduces the most important administrative tools and user interfaces: mysql, mysqladmin, mysqldump; the programs MySQL Administrator, MySQL Query Browser; and finally phpMyAdmin. The latter program is particularly well suited for off-site administration using a web browser. A separate chapter shows how Micro$oft Office, Sun StarOffice, and OpenOffice can be used to access MySQL databases.

TABLE OF CONTENT:
Chapter 01 - What Is MySQL?
Chapter 02 - The Test Environment
Chapter 03 - Introductory Example (An Opinion Poll with PHP)
Chapter 04 - mysql,mysqladmin,and mysqldump
Chapter 05 - MySQL Administrator and MySQL Query Browser
Chapter 06 - phpMyAdmin
Chapter 07 - Micro$oft Office,OpenOffice/StarOffice
Chapter 08 - Database Design
Chapter 09 - An Introduction to SQL
Chapter 10 - SQL Recipes
Chapter 11 - Access Administration and Security
Chapter 12 - GIS Functions
Chapter 13 - Stored Procedures and Triggers
Chapter 14 - Administration and Server Configuration
Chapter 15 - PHP
Chapter 16 - Perl
Chapter 17 - Java (JDBC and Connector/J)
Chapter 18 - C
Chapter 19 - Visual Basic 6/VBA
Chapter 20 - Visual Basic .NET and C#
Chapter 21 - SQL Reference
Chapter 22 - MySQL Tools and Options
Chapter 23 - API Reference
Appendix A - Glossary
Appendix B - The Files for this Book
Appendix C - Bibliography

You can never have enough Tetris on a Friday.

Sergey Popov created this version. Play away.