472,145 Members | 1,556 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

Upgrading MySQL 4.1 to 5.0

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.
Jan 10 '07 #1
1 1267
4,258 Expert 4TB
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:
Jan 10 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Jonathan Hilgeman | last post: by
reply views Thread by Nikola Skoric | last post: by
2 posts views Thread by wellington fan | last post: by
3 posts views Thread by Richard Petty | last post: by
5 posts views Thread by Shiraz | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.