Select query not working when trying to get records for column with column name 'ssl'

Question

Select query not working when trying to get records for column with column name 'ssl'

Can someone please tell me what is wrong with this query?

mysql> select dom_id, ssl from hosting;

I am getting below error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'ssl from hosting' at line 1

If I remove the ssl then the query gives the result as it should.

Note. Both dom_id and ssl are two columns of the hosting table.

+3

mysql

jyotiprakash 23 Aug At 4:26 am

source to share

2 answers

All MySQL reserves the shloud words between "` "to work properly.

0

vinibarr 23 Aug 14 at 5:48 am

source to share

Manisha patel · Accepted Answer · 2014-08-23T04:30:07+0000

Try this

select `dom_id`, `ssl` from hosting;

ssl is a keyword for mysql. So please use "` "this sign

Select query not working when trying to get records for column with column name 'ssl'

More articles: