Ask the Expert

MySQL's stored procedure support

MySQL is planning to support stored procedures in 5.0, but is implementing its own stored procedure language, rather than using Java as the stored procedure language. Any idea as to why this approach is being taken?

    Requires Free Membership to View

The ANSI SQL standard specifies a language for stored procedures, and as MySQL AB has ANSI SQL standards compliance as a goal, they will be following the standard rather than implementing a language such as Java. MySQL's stored procedure syntax will be closest to IBM's DB2, which also follows the SQL standard for stored procedures.

For More Information


This was first published in June 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: