search

scraperwiki / quick-nerdy-sql-tool

A ScraperWiki view tool for geeks who know SQL well, it returns JSON.
0 stars 1 forks source link

If the table has a column with a space in, the first SQL query has bad syntax and won't work. #23

Open drj11 opened 11 years ago

drj11 commented 11 years ago

For example, I have a (typed in) dataset with a column called "Geek superpower". When I first use the SQL tool the query shown is:

select 
    Name,
    Geek superpower
from data
limit 20

and the result shown is:

Error in SQL

SQL error: no such column: Geek