What are the reserved words that cannot be used in the SQL query for indexing content, and how can I overcome the reserved word issue?

The following are the reserved words to be avoided within your SQL query:

* indexdate
* Lastmodified
* Colname
* url
* size
* col

You can use these reserved keywords through an alias as in the example query:

@@@
Select *, id as “uid”, indexdate as “mydate”, url as “myurl” from <tablename>;
@@@

Have more questions? Submit a request

Comments