White Papers

MySQL 5.0 Stored Procedures: MySQL 5.0 New Features Series - Part 1

Overview A stored procedure is a procedure (like a subprogram in a regular computing language) that is stored (in the database). Correctly speaking, MySQL supports "Routines" and there are two kinds of routines: stored procedures which a person calls, or functions whose return values are used in other SQL statements the same way that is used pre-installed MySQL functions like pi(). This paper is for long-time MySQL users who wants to know "What's new" in version 5. The short answer is "Stored procedures, triggers, views, information_schema".

Download White Paper

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher
MySQL
File Format
PDF
Date Published
Aug 26, 2006
Format
White Papers
Topics
Database Management

Similiar White Papers

BPM Done Right: 15 Ways To Succeed Where Others Have Failed

BPM Done Right: 15 Ways To Succeed Where Others Have Failed

Business Process Management (BPM) promises are real, but the path to success is littered with pitfalls and shortcuts to

Publisher: Software AG

SQL Server 2000 Enterprise Edition (64-bit): Advantages of a 64-Bit Environment

SQL Server 2000 Enterprise Edition (64-bit): Advantages of a 64-Bit Environment

HP has partnered with Microsoft to provide information about the advantages of a 64-Bit Environment. Microsoft SQL Serv

Publisher: Hewlett-Packard  |  Tags: applications, software

The ROI of Data Governance - A Revenue Generation Perspective

The ROI of Data Governance - A Revenue Generation Perspective

"Concentrating on increasing revenue necessarily means paying attention to metrics such as return on investment (ROI). T

Publisher: DataFlux  |  Tags: data, metadata

Fibre Channel and iSCSI Performance Comparison for DSS Workloads Using SQL Server 2005

Fibre Channel and iSCSI Performance Comparison for DSS Workloads Using SQL Server 2005

For many years, large enterprises have relied on Fibre Channel (FCP) as the default Storage Area Network (SAN) protocol

Publisher: Network Appliance (NetApp)  |  Tags: database, ethernet, ip, tco

Quickly import data into Excel with these techniques

Quickly import data into Excel with these techniques

This sample chapter, taken from Managing Data with Excel, highlights a couple ways to get data from other applica

Publisher: TechRepublic  |  Tags: applications, data, excel

MySQL White Papers

Greyhound-Data Dog Racing Site Relies on the Speed of MySQL

Greyhound-Data Dog Racing Site Relies on the Speed of MySQL

Greyhound-Data is the world's most popular greyhound racing web site. It is the de facto web site for greyhound fans in

Publisher: MySQL

Migrating From Microsoft SQL Server to MySQL Databases Running on Linux

Migrating From Microsoft SQL Server to MySQL Databases Running on Linux

In today's market, it is of utmost importance to improve IT system and processes while reducing the cost associated with

Publisher: MySQL  |  Tags: database, linux

MySQL Case Study: Nasa

MySQL Case Study: Nasa

The NASA Acquisition Internet Service is responsible for providing the general public with information regarding contrac

Publisher: MySQL  |  Tags: database, network

A Guide to Developing an Enterprise Open Source Strategy: The Rise of Open Source and the LAMP Stack

A Guide to Developing an Enterprise Open Source Strategy: The Rise of Open Source and the LAMP Stack

Not only is open source ready for the enterprise, it's also proven there. Many of the world's largest organizations, inc

Publisher: MySQL  |  Tags: applications, cost savings, enterprise applications, linux, open source, php, software, yahoo!

Utel Handles 10,000 Requests Per Second Using a Scale Out Deployment of MySQL Network

Utel Handles 10,000 Requests Per Second Using a Scale Out Deployment of MySQL Network

Utel's bet was to develop France's biggest mobile phone-based chat community! In March 2003, the company launched "Fotoc

Publisher: MySQL