Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

But...why? They are used to configure the mysql session.
–
Derek DowneyJul 25 '11 at 17:51

That's why I said I would it leave everything be. One could take a chance and strip those directives leaving just the commands. Then, one could just stay stuck in whatever version of MySQL one is using at the time. I once had a boss about 5 years ago that wanted Stored Procedures in PVCS with the directives stripped. It was needless to me, but that's what my boss wanted. The scripts worked on reload but were no longer guaranteed to be portable to other versions of MySQL. Again, I would just leave it be.
–
RolandoMySQLDBAJul 25 '11 at 17:56

@DTest The comments around the SET directive are ok and they are useful for portability. What annoys me are the comments around the creation of the stored procedure itself: /*!50003 CREATE*/ and /*!50003 PROCEDURE LoadMyData() ... END */;;
–
Chaker NakhliJul 28 '11 at 8:09

@Chaker Unfortunately, Stored Procedures came into existence in MySQL 5.0. Therefore, the directives have to remain.
–
RolandoMySQLDBAJul 28 '11 at 12:14