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:
sp_shortdocs(id INTEGER UNSIGNED)
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.