Upgrading MySQL 4.1 to 5.0

[prileep]

I want to create procedures,triggers and functions in MySQL,but i am using Version 4.1.14. So if i upgrade it to Version 5.0 can i create these objects which will function as SQL Server 2000-Transact SQL
Is it backward compatible to version 4.1.14 so that it should not affect existing database.

[ronverdonk]

No, you are not backward compatible because support for triggers is included beginning with MySQL 5.0.2. and stored routines (procedures and functions) are supported from MySQL 5.0.

Ronald :cool: