Add to the connection string
Allow User Variables=TrueBecause the SQL statement contains custom parameters, such as @ rownum
allow user variables = true allows users to customize parameters.
Read More:
- C ා connect mysql: fatal error encountered during command execution solution
- How to solve the problem of “08001” when JDBC connects to MySQL
- Android: How to Solve Execution failed for task ‘:app:compileDebugJavaWithJavac‘. ＞ javax/xml/bind/JAXBException
- How to solve fatal error C1010!
- How to Solve MacOS Big Sur MySQL workbench flashback problem
- Linux basic command execution error: the solution of command not found
- How to Solve Vue Command Not Work Issue in win7_64
- The idea code pushes to GitHub and reports an error fatal: unable to access
- Systemctl command doesn’t exist. How to solve the problem that the service can’t be started
- To solve the execution failed for task ‘: app:transformDexArchiveWithDexMergerForDebug ‘
- FTP use get command 550 failed to open file, but use the put command to solve the problem
- How to use matlab to solve equation
- Jstack command execution error: unable to open socket file: target process not responding or hotspot VM not loaded
- How to solve MySQL error 1049 (42000): unknown database ‘database’
- Chrome failed to access MSDN home page. The specified CGI application encoded an error and the server terminated the
- Fatal error: Uncaught Error: Call to undefined function mysql_ Connect() problem solving
- Mysql reports an error Operand should contain 1 column(s)
- Zeppelin uses spark to connect to MySQL and reports an error
- Error in Cordova project execution command after Android studio upgrade: could not find gradle wrapper within Android SDK
- How to view the version of MySQL database