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:

    CONVENTIONS MEANING EXAMPLE
    Square Brackets [ ] Indicates that the enclosed arguments are optional in the syntax DIGITS [. 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 times SELECT 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 CASE Uppercase text indicates case-insensitive filenames or directory names, commands, command keywords, initializing parameters, data types. SELECT column_name FROM table_name
    lower case Lowercase 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_clause WHERE (<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_clause GROUP BY expression ( "," expression )*
    having_clause HAVING condition
    order_by_clause ORDER BY (order_item_clause) ( "," order_item_clause )*
    limit_clause LIMIT (value | ALL) [ "," value ]
    join_clause table_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

     

    Copyright © 2016, ZOHO Corp. All Rights Reserved.