Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 2 Current »

Supported MySQL Statements and Uses

MySQL is used in the following All On Mobile functionality:

  • Visibility
  • Paging
  • Off-line Databases' for dropdown menus and validation
  • Simple calculations (+ / - *)
  • Validation of a Field’s contents

Supported SQL Statement

MySQLExamplesNotes
SELECT, LIKE & WHERESELECT Employee_Name, Employee_DOB FROM Employees WHERE Employee_Name LIKE ‘Dave%’ LIMIT 20

It is important to LIMIT the results when the SELECT or LIKE functions are used. This prevents to many results from being displayed and slowing the mobile device.

NOTE:
Nested SELECTS are not supported.

Where you are likely to return over 50 results use LIMIT to restrict the returned results to a manageable number.

=, !=, >, <, >=, ==, <>
  • SELECT * FROM Products WHERE Item_Id == 1
  • SELECT * FROM Products WHERE Price >= 30
  • SELECT * FROM Products WHERE Category != ‘Pet_Food’

A list of SQL Operators and their function can be found at:

https://www.w3schools.com/sql/sql_operators.asp

AND & ORSELECT * FROM Customers WHERE Country = 'Germany' AND (City = 'Berlin' OR City = ‘München')Remember to use parenthesis to form complex expressions otherwise you may end up with conflicting logical operators.
+ & - SELECT ${Price} + ${VAT} - ${Discount}Simple addition and subtraction operators.
  • No labels