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?
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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
- Dozens more answers to tough MySQL questions from Mike Hillyer are available here.
- The Best MySQL Web Links: tips, tutorials, scripts, and more.
- Ask the Experts yourself: Our SQL, database design, SQL Server, DB2, Sybase, MySQL, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Dig Deeper on Open source databases
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.