sql - Syntax error when selecting column 'Comment' in Sybase IQ -


i have table columns in sybase iq. 1 of columns named "comment".

whenever select column:

select comment 

i got error:

[error code: 102, sql state: 42w04]  sql anywhere error -131: syntax error near 'comment' 

i able select other columns without issues. advise reason , solution? thank you

try

select "comment" 

comment reserved word in sybase iq.

here the link explaining problem.

some keywords in sql reserved words. use reserved word in sql statement identifier, must enclose word in double quotes. many, not all, of keywords appear in sql statements reserved words. example, must use following syntax retrieve contents of table named select.

select * "select"


Comments

Popular posts from this blog

python - Selenium remoteWebDriver (& SauceLabs) Firefox moseMoveTo action exception -

html - How to custom Bootstrap grid height? -

transpose - Maple isnt executing function but prints function term -