常见错误及处理办法

  1、[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '***'

  很简单,1064即为SQL语法错误,仔细检查错误提示信息所指语句附近改正即可。

  2、[Err] 1318 - Incorrect number of arguments for PROCEDURE *.*; expected *, got *

  如提示信息,database_name.procedure_name的存储过程传入的参数个数不对。

  3、[Err] 1414 - OUT or INOUT argument 1 for routine *.* is not a variable or NEW pseudo-variable in BEFORE trigger

  此信息也是提示我们传入的参数不对,*.*的存储过程参数为输出(或输入)参数,而我们可能传入相反的参数,例如要求为输出参数,而我们传入的参数非会话变量,即会报此错。