EC
3190
MySQLERRORNotableQuery SyntaxHIGH confidence

Invalid number of arguments

Production Risk

Low — caught at parse time.

Why it happens
  1. 1Calling a function with too many or too few arguments.
  2. 2Function signature mismatch between called arity and expected arity.
How to reproduce
trigger — this will error
trigger — this will error
SELECT SUBSTR('hello');

expected output

ERROR 3190 (HY000): Incorrect number of arguments for function.

Fix

Provide the correct number of arguments

Provide the correct number of arguments
SELECT SUBSTR('hello', 1, 3);

Why this works

Check the function signature and supply all required parameters.

What not to do

✕

Sources
Official documentation ↗

MySQL 8.0 — 3190 ER_INVALID_NO_OF_ARGS

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MySQL errors