I am currently migrating a database from mssql to mysql.
This mssql database has (sigh) many stored procedures in it. These
stored procedures are automatically generated from a UML model.
I am trying to change the UML model to generate C code so I can create
user defined functions with the same functionality as the mssql stored
procedures.
[I eagerly look forward to mySQL stored procedures - my server is going
way to fast :-) ]
This UML generation also creates a script to populate the database
server with the "stored procedures" using "create function" calls (or in
the case of mssql, using "create procedure" calls).
The MS SQL Server generated script contains code that deletes the stored
procedure if it exists (prior to recreating it) using code that looks
like this....
-- snip
IF EXISTS (SELECT * FROM sysobjects WHERE uid=user_id()
AND type='P'
AND name='InfDropCurrentParametersTable')
BEGIN
PRINT ' > DROPPING - InfDropCurrentParametersTable ...'
DROP PROCEDURE InfDropCurrentParametersTable
END
GO
...
-- snip
Is there any way of doing a similiar check in MySQL? I know I can just do a
DROP FUNCTION InfDropCurrentParametersTable;
and live with the error if it doesn't exist, but it would be nice to
make the script tidy.
Many regards,
Ian Collins.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
