why don't you try it and see? (altho I suspect that using 'count' as the
result field name might not work, and that having column names with spaces
in them will require quotes around them.)
Rikin Parekh riki...@gmail.com wrote in message
This is the sample data provided to me. I need to query this data only. And
column name can be without spaces. I need to know the query that will give me
the result irrespective of the syntax errors in question table. Can someone
please guide or help?
Thanks,
Rikin
On Apr 13, 2012, at 9:12,
Rikin Parekh riki...@gmail.com wrote in message
news:fad9d02d-2add-4a31-b118-81d56183e...@gmail.com...
This is the sample data provided to me. I need to query this data only. And
column name can be without spaces. I need to know the query that will give
me the result irrespective of the syntax
I got the answer. My query works perfectly fine. Earlier I had problems in
configuring mySQL Workbench so I could not try.
Thank you guys.
Rikin
On Fri, Apr 13, 2012 at 10:28 AM, Jim Giner jim.gi...@albanyhandball.comwrote:
Rikin Parekh riki...@gmail.com wrote in message
Rikin Parekh rpare...@umd.edu wrote in message
news:CALbBjtctPawe=qyuvqWZvG3nq_Tw7PwKoe-hhi5fkYGec=6...@mail.gmail.com...
I got the answer. My query works perfectly fine. Earlier I had problems in
configuring mySQL Workbench so I could not try.
Thank you guys.
Rikin
No thanks necessary.