upgrading to MySql 5

[Michaelttkk]

Hi! I've been using MySql 4.1.11 and I read on the www.mysql.com but I'd like to get some opinion.

what version is best for
1. easy to code with php and free ^^ I'm broke and in the learning stage
2. useful

and if ever I should umm rather I want to upgrade to MySql 5 how can I accomplish that and what might some benefits there be

Thanks in advanced!

[chazzy]

MySQL 5 is a vast improvement over the previous versions. It is the first version that supports stored procedures, views, and triggers (though trigger support is somewhat weird).