This presentation is intended to get beyond the basic usage of stored routines. We are going to explain stored routines behavior in detail referring to the underlying MySQL server concepts and design decisions. Basically this presentation will consist of two major blocks: explaining tricky or not obvious features of stored routine behavior and providing examples of advanced use.
Topics will include:
Here we’ll talk about two different arithmetics in MySQL: item and field arithmetic. The item-arithmetic is weakly typed and is used in SELECT statements. The field-arithmetic is strictly typed and is used for inserting data into tables. Stored routine variables work according to the field-arithmetic.
Alexander Nozdrin is a software developer at MySQL AB. He has been working for the company since 2005 as a runtime team member. Alexander works mainly on standard-compliance aspects of stored programs, character set support and the client server protocol.
Over 18 years database and developer consulting experience. Has led project efforts in launching new technologies internally to three of the top ten software companies in the world. Primary focus the last seven years has been in working with Fortune 1000 companies in migrating to leading edge database and middleware technologies. George Trujillo is recognized internationally for his expertise in database technology and has been selected as a keynote and master presenter at numerous business and technical conferences. Strong database experience in high availability, performance tuning, replication, clusters and backup and recovery. Middleware experience includes J2EE, Application Development Frameworks, Application Servers, Web Services, XML, SOA, BPEL and Business Rules. George has served on board of directors for different International technology user groups, technology councils for top software companies as well as beta leadership councils for top ten software vendors.
View a complete list of MySQL contacts.