Summary of statements in mysql that can be executed without ending symbols

It is well known that every executable statement executed by mysql ends with a semicolon , that is to say, mysql Identifying whether a statement ends is determined by the semicolon.

Of course, you can also use DELIMITER to customize the end symbol of a statement.

I don’t know if you have noticed that , there are also some statements that do not require end symbols. For example:

mysql> use trains
Database changed

Obviously, using the USE TRAINS statement to specify the use of a certain database does not require the end symbol. Of course, you can add the end symbol.

Of course, the execution of the EXIT (exit) command does not require an end symbol.

If you have anything to add, please reply to me below.

The above is the detailed content of Summary of statements in mysql that can be executed without ending symbols. For more information, please follow other related articles on the PHP Chinese website!