Analytics-Plus Help

MySQL - Supported SQL syntax and Functions in Zoho Reports

ManageEngine Reports supports MySQL SELECT query syntax and in-built functions in CloudSQL. Following are the MySQL syntax which are supported in Zoho Reports.

Supported MySQL SELECT Query Syntax:

Following are the conventions used in the SELECT syntax definition:

CONVENTIONSMEANINGEXAMPLE
Square Brackets [ ]Indicates that the enclosed arguments are optional in the syntaxDIGITS [. PRECISION ]
Braces followed by plus sign ( )+Indicates that the enclosed arguments can occur more than once( DIGIT )+
Braces followed by star sign ( )*Indicates that the enclosed arguments can occur zero or more timesSELECT column_name ( , column_name)* FROM table_name
Question Mark ?Indicates that the Question mark "?" preceded by an argument is optional. Equivalent to Square Brackets[ ]<INTEGER> ( "." <INTEGER> )?
Vectical Line |Vertical Line indicates choices(DISTINCT | ALL | UNIQUE )
UPPER CASEUppercase text indicates case-insensitive filenames or directory names, commands, command keywords, initializing parameters, data types.SELECT column_name FROM table_name
lower caseLowercase text indicates database objects like table name, column names etc.DELETE FROM table_name WHERE condition

SELECT Syntax:

SELECT [ DISTINCT | ALL ] ( ( column_clause ( "," column_clause )* ) | "*" ) [ FROM table_expression_clause ]
[ where_clause ] [ group_by_clause ] [ having_clause ] [ order_by_clause ] [ limit_clause ]

column_clause( expression | table_name.* | table_name.columnname | table_name.column_name | column_name ) [ [ AS ] alias_name ]
table_expression_clause( table_name ) [ AS alias_name ] ( "," ( table_name ) [ AS alias_name ])*
[join_clause ]
where_clauseWHERE (<Left Where Expression>(= | < | > | <= | >= | != | LIKE | NOT LIKE | BETWEEN) <Right Where Expression>) ( (OPERATOR) (<Left Where Expression> (= | < | > | <= | >= | != | LIKE | NOT LIKE | BETWEEN) <Right Where Expression>)*

OPERATOR includes AND/OR

group_by_clauseGROUP BY expression ( "," expression )*
having_clauseHAVING condition
order_by_clauseORDER BY (order_item_clause) ( "," order_item_clause )*
limit_clauseLIMIT (value | ALL) [ "," value ]
join_clausetable_name INNER JOIN table_name ON join_condition |
table_name {LEFT | RIGHT} [OUTER] JOIN table_name ON join_condition
order_item_clause(expression | column name) [ ASC | DESC ]

UNION Syntax:

<SELECT Query Statement> (UNION [ALL | DISTINCT] <SELECT Query Statement>)+

Reference:MySQL SELECT Query syntax documentation

Next: Supported built-in Functions in MySQL

Share this post : FacebookTwitter