Geek Answers Handbook

How to determine the current delimiter in MySQL?

Is there a way to determine the current delimiter in MySQL?

The delimiter can be set as follows: DELIMITER //

Or like this: \d //

But how do you get the current separator?

I tried to view the results of SHOW STATUS and SHOW VARIABLES no avail.

+7
mysql delimiter
source share
2 answers

If you just want to know which separator is set right now, \s will show you that:

Using delimiter: //

+4
source share

The delimiter is not a keyword or command on the server (it is not even a reserved keyword), so there is absolutely no way to return it from the server (since the server does not know about it)

It is used by the client (and the client must support it), and only by the client.

If you try to send DELIMITER // from a client that does not support it, you will get a syntax error

+1
source share

More articles:


All Articles