MySQL statements without delimiter

There are two statements in MySQL that do not require the end delimiter (which is ‘;’ by default). These statements are as given below:


The USE statement is used to select the database in MySQL as your current database. The database selected by USE statement remains default until you change it with another USE statement or the command line session expires. Also it does not harm if you write ‘;’ or the delimiter used by you to end the USE statement. The syntax for use statement is as below:

USE db1; or USE db1 both will work

where db1 is the name of the database.


The above statement is used to quit your current MySQL client session. This command does not affect any nodes connected to the cluster.