-
Stored Procedures Getting Dropped
We're running MySQL 5.0.18 which supports stored procedures. However, I can only create one at a time. If I create a stored proc and go to create another, the previous is dropped. Say, for example, I have a SP called spCUSTOMERS. If I go to create another SP, say spVENDORS, the spCUSTOMERS is gone. Has anyone experienced this and is their a fix?
The latest patches were applied to our server (Win 2003) so I can't understand why this is happening. For whatever it's worth, the same thing is happens when creating views. I create view1 successfully. But if I create view2, view one is gone. I'm new to MySQL so this is not creating a good impression.
Brian
-
just wondering, what syntax are you using to create the procedures?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|