Mysql reset delimiter to normal ';'

0
votes

I have typed:

DELIMITER DELIMITER

Just trying to figure it out how to set my delimiter to normal ';' again;

1
mysqlstrange-attractor
DELIMITER ; should work. – Gordon Linoff

1 Answers

1
votes

Once you set a different delimiter all the query statement will expect that delimiter to be used 

delimiter delimiter 

select * from users ; // This would do nothing

But

select * from users delimiter

will list the users since once it encounters delimiter which is your defined delimiter the statement will be executed.

To go back you need to use

delimiter ;