ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

Issues Querying Table with name Containing Spaces

mysql

#1

Hi,

I am having issues with simple SQL Statement where we have spaces in the names.

For Example “tabPayment Entry”, “tabStock Entry”.

I am currently running my script in terminal.

Any help who encounterd this.

Thanks


#2

Hi @mahima98,
When you want to query a table who contain spaces, you need to use backtick ` (not the same thing as: ’ )
so your query would look like this:

`tabPayment Entry`
or
`tabPayment Entry`.name

Hope this helps!