Demand scenario:
when deploying the production environment, you need to run the SQL script uploaded locally
Problem Description:
the local script runs normally, and liunux reports syntax error </ font>
syntax error
Cause analysis:
when running stored procedures or a long string of SQL scripts in Linux, you need to add fixed syntax at the beginning and end
beginning: \set sqlterm/
end:/\ set sqlterm
Solution:
add fixed statements \set sqlterm/and
/\ set sqlterm
as shown in the figure:
Read More:
- [Solved] Linux shell Script Error: syntax error near unexpected token `do
- Windows writes shell script and executes shell error [Solved]
- Ubuntu shell Script syntax error near unexpected token `$‘{\r‘‘
- Shell Script syntax error near unexpected token `done’
- Running shell script reports an error: “syntax error near unexpected token solution ‘”
- [Solved] RHEL 7 installs Oracle RAC 11.2.0.4, executes root.sh error ohasd: failed to start
- [Solved] yum command Error: “except keyboardinterrupt, e: syntax error: invalid syntax”“
- Sublime text 3 compiles and executes C/C++ programs directly
- [Solved] Linux — 9 — txt files are copied from windows to Linux and read error
- [Solved] Linux Error: mipsel-linux-gcc: fatal error: no input files
- npm ERR! Failed at the [email protected] install script.
- subprocess installed post-installation script returned error exit status 1
- [Solved] sbatch: error: Batch script contains DOS line breaks (\r\n)
- ubuntu install package Error: subprocess installed post-installation script returned error exit status 10
- [Solved] Shell error: syntax error: unexpected end of file
- [Solved] Ubuntu Terminal Error: subprocess installed post-installation script returned error exit status 1
- Parse error in ubantu/Linux system [How to Solve]
- linux(aarch64): How to Fix kettle Startup Error Issue
- [Solved] sys.stderr.write(f“ERROR: {exc}“) SyntaxError: invalid syntax
- [Solved] Except CvBridgeError,e:SyntaxError:invalid syntax