469,636 Members | 1,815 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,636 developers. It's quick & easy.

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 1228
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 gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.