Modify the usage of the command terminator delimiter in MySQL

Little scum · Posted on 10/11/2016 9:13:45 AM

How to modify the command terminator delimiter in MySQL:
The delimiter in MySQL will tell the MySQL interpreter what the ending character of the command is, and by default MySQL commands are written with a semicolon (; Ended. After encountering (; MySQL can execute the command.
See the following example:
mysql>delimiter $
It tells the MySQL interpreter to execute the command when it encounters $.
Example 1: mysql>select * from temp; #回车时就会执行这条语句
Example 2: mysql>delimiter$
mysql>select * from temp; #回车时不会执行
->$#在此回车才会执行上述语句
mysql>delimiter ; #将命令结束符重新设定为(; )
Usually, we use it when creating stored procedures, functions, and views!

[Source] Modify the usage of the command terminator delimiter in MySQL

Related Posts

Sections viewed