博文背景 mycli是个好用的mysql命令行工具,但是由于上游解析库的原因,它不支持使用delimiter语句来更换分隔符,需要有其他解决办法来在命令行中创建存储过程和函数 具体操作 There is a neat workaround since version 1.20.0: you can switch to single-line mode and break lines with Alt-Enter. It allows you to create multi-line stored procedures without changing delimiters: 参考链接 https://github.com/dbcli/mycli/issues/383