Page 1 of 2

MySQL DELIMITER statement

PostPosted: Fri Jan 11, 2013 9:46 am
by 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.

Re: MySQL DELIMITER statement

PostPosted: Mon Jan 14, 2013 10:45 am
by 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!

Re: MySQL DELIMITER statement

PostPosted: Mon Mar 16, 2015 11:33 am
by endo
Any update on this issue?

Re: MySQL DELIMITER statement

PostPosted: Fri Mar 27, 2015 3:37 am
by 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 :)

Re: MySQL DELIMITER statement

PostPosted: Thu Apr 02, 2015 1:40 pm
by 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

Re: MySQL DELIMITER statement

PostPosted: Mon Apr 27, 2015 8:35 am
by 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.

Re: MySQL DELIMITER statement

PostPosted: Mon Apr 27, 2015 11:56 am
by Serge
Priority of this feature was increased, hopefully next version of DBeaver will have support of custom delimiters.

Re: MySQL DELIMITER statement

PostPosted: Tue May 19, 2015 10:27 am
by Serge
Version 3.4.0 supports custom script delimiters:
sql-delimiter-config.png
sql-delimiter-config.png (19.31 KiB) Viewed 104023 times

Re: MySQL DELIMITER statement

PostPosted: Tue Dec 01, 2015 2:25 pm
by 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`();

Re: MySQL DELIMITER statement

PostPosted: Sat Jan 09, 2016 10:27 pm
by tb_ai