Statements And Functions

• MySQL has the following features regarding SQL statements and functions:
  • Full operator and function support in the SELECT list and WHERE clause.
    • For example:

      mysql> SELECT CONCAT(first, ' ', last)
-> FROM taxpayer
-> WHERE income/dependents > 50000 AND age > 64;

  • Full support for SQL GROUP BY and ORDER BY clauses.
  • Support for LEFT OUTER JOIN and RIGHT OUTER JOIN with both standard SQL and ODBC syntax.
  • Support for aliases on tables and columns as required by standard SQL.
  • The MySQL-specific SHOW statement can be used to retrieve information about databases, storage engines, tables, and indexes.
  • The EXPLAIN statement can be used to determine how the optimizer resolves a query.
  • Function names do not clash with table or column names.
    • ABS is a valid column name.
      • The only restriction is that for a function call, no spaces are allowed between the function name and the ‘(’ that follows it.
  • Ability to refer to tables from different databases in the same statement.

What are the security features?

---

---

© 2007 John Michael Pierobon

Notes