SQLConstants
Is a collection of constants used in the SQL context.
The naming convention for those constants which are part of query such where, values, etc... is:
the underscore character (_) stands for whitespace, so the _WHERE_ constant value is:
WHERE
Provided constants
| Key | Value |
|---|---|
| SINGLE_QUOTE | ' |
| OPENED_ROUND_BRACKET | ( |
| CLOSED_ROUND_BRACKET | ) |
| COMMA | , |
| QUESTION_MARK | ? |
| DELETE_FROM_ | DELETE FROM |
| _VALUES_ | VALUES |
| _WHERE_ | WHERE |
| _IN_CLAUSE_ | IN |
| ALTER_TABLE_ | ALTER TABLE |
| SHOW_INDEX_FROM_ | SHOW INDEX FROM |
| _ADD_FULLTEXT_INDEX_ | ADD FULLTEXT INDEX %s ( |
| _IN_NATURAL_LANGUAGE_MODE | IN NATURAL LANGUAGE MODE |
| _IN_BOOLEAN_MODE | IN BOOLEAN MODE |