MySQL 5.0 Now Available for Production Use

MySQL 5.0 is out. It now supports:

  • Stored Procedures and SQL Functions (about time!);
  • Triggers (about time!);
  • Views (about time!);
  • Cursors (about time!);
  • Information Schema — to provide easy access to metadata (I don’t know what this is);
  • XA Distributed Transactions — supports complex transactions across multiple databases in heterogeneous environments (sounds good);
  • SQL Mode — provides server-enforced data integrity for new and existing data (about time!).

However, I wouldn’t switch over any serious Enterprise project to MySQL with Oracle buying InnoDB and all, but if you are already using MySQL, this is good news indeed.

Published by

Daniel Lemire

A computer science professor at the University of Quebec (TELUQ).

Leave a Reply

Your email address will not be published.

To create code blocks or other preformatted text, indent by four spaces:

    This will be displayed in a monospaced font. The first four 
    spaces will be stripped off, but all other whitespace
    will be preserved.
    Markdown is turned off in code blocks:
     [This is not a link](

To create not a block, but an inline code span, use backticks:

Here is some inline `code`.

For more help see

You may subscribe to this blog by email.