SQL Syntax Considerations
From LongJump Support Wiki
Revision as of 19:52, 1 February 2012 by imported>Aeric
- Considerations
-
- SQL syntax is not case-sensitive, except for table names and field names.
- Backticks are (`) are needed around any table or field name that is one of the SQL Reserved Words.
- For example: SELECT * FROM `Order`
- Without the backticks, you get an error like this:
- Encountered "Order" at line column 15. Was expecting one of (...
- That error means the parser found a word it recognized, but didn't find other things it expected before it got to that word.
- When either a table name or a field name is reserved word, and both are used together, then backticks are needed around the combination.
- For example: `Order.order_number`
- If you do a query on different tables that have fields with the same name, you must provide column aliases to identify those fields. (If you query A.phone and B.phone, both sets of values will be identified as "phone", unless you specify a column alias for at least one of them.)
- Learn more: column_expr