MySQL DELIMITER statement

[erseco]

It would be interesting support the MySQL DELIMITER statement to expedite the development and testing of stored procedures and functions.

Thanks!


In spanish:
Sería interesante soportar el DELIMITER de MySQL para agilizar el desarrollo y testeo de funciones y procedimientos almacenados.

[Serge]

Hello,

Yes, we are going to add this feature (not only for MySQL). Generally it's quite not easy feature (as we need to make complex analysis of SQL script) but hopefully it'll be implemented soon.

Thanks!

[endo]

Any update on this issue?

[carlosspohr]

It will beautiful when implemented on DBeaver!

@Serge, I can test this feature for mysql db if you want.

..every day I need to use cmd or terminal to run my procedures coded in DBeaver

[guni82]

Hi!

Setting the delimiter would be a great and essential feature!
I'm using triggers and procedures in Firebird a lot and can't import them from a script at the moment.

I could even live with an option to change the standard delimiter from ; to something else.
There is an option called Script Delimiter in Avanced Firebird Driver Parameters. It activates e.g. $$ as a delimiter but unfortunately doesn't deactivate ;

However, congrats to your great work!

Thanks

[mickmcg]

Just discovered DBeaver and it is best tool of this kind I have used. However the lack of support for DELIMITER in MySQL means I can't run scripts to create Stored Procedures so I still need to revert to other tools when I would prefer to just use this one.

Any fixes or workaround much appreciated.

[Serge]

Priority of this feature was increased, hopefully next version of DBeaver will have support of custom delimiters.

[Serge]

Version 3.4.0 supports custom script delimiters:

sql-delimiter-config.png (19.31 KiB) Viewed 100296 times

[aleishman]

Your tool is absolutely awesome but the delimiter thing is a serious issue. Being ablt to set and change the delimiter at will in a long script file is extremely important.

Here is an example of a script:

delimiter $$
drop PROCEDURE if exists `prc_AddVote`$$
CREATE PROCEDURE `prc_AddVote`(
)
begin
-- script code ;
end
$$

delimiter ;
call `prc_AddVote`();

[tb_ai]