General Notes

  • A query must at least select one field, otherwise no result will be returned.
  • Unsigned integers are not natively supported for the database. Therefore, a WHERE for variables of this type might provide unexpected query results.
  • Requesting an" unsigned int" from the database, requires to manually cast the result value to an unsigned type.
  • The time column is always in UTC time and it is always retrieved as the first column.