mismatched input '*' expecting ...

ErrorCode

ParameterInvalid

ErrorMessage

line 1:76: mismatched input '$' expecting

Error description

The SQL statement has a syntax error, or an input character does not meet expectations.

Cause

The SQL statement contains unrecognized characters or operators. For example, part of the parentheses or quotation marks is missing or the operator is incorrect.

Solution

Check whether the SQL statement contains a syntax error. If yes, fix the error accordingly.You can use an SQL editing tool or online SQL verification tool for verification and debugging.We recommend that you build the SQL statement step by step to ensure that each part can be correctly executed. This prevents syntax errors.