Error with running SQL Query

Question

Error with running below SQL Query: 

dbGetQuery(db,' select * from "offices" ')

dbGetQuery(db,'select * from "offices"')
Error: <SQL> 'select * from "offices"'
  nanodbc/nanodbc.cpp:1587: 42000: [MySQL][ODBC 5.3(a) Driver][mysqld-5.5.5-10.3.16-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"offices"' at line 1 

Answer 1

Use below code.

ofc <- dbGetQuery(db,'select * from offices')