How to generate DDL script (for mysql) which contains common objects (tables) and stored procedures/triggers? SPs/TRGs requires special syntax - changing delimiter to another one.
In common it looks like this:
DELIMITER $$
CREATE PROCEDURE sp_shortdocs
(id INTEGER UNSIGNED)
BEGIN
some;
statements;
END $$
DELIMITER ;
Is it possible to achieve it automatically? Fixing script manually is not what I want to do daily.
Currently, I have to change delimiter during script generating but it affects whole generated script.
By the way one more think I reported a year ago (valid for all dbs)
Please generate default delimiter (semicolon) in the line of the statement. Adding it a line bellow makes script quite unreadable.