I try to do:
select * from 'foo-bar';
in the mysql CLI but I get a syntax error near ''foo-bar''. I guess that is due to the hyphen in the table name.
How can i resolve that issue?
Asked
Active
Viewed 13 times
0
-
it does neither work with single nor mit double quotes – Maaaaa Dec 06 '17 at 18:27
-
That's because both of those options are incorrect. Please refer to the linked duplicate. – David Dec 06 '17 at 18:28
-
Oh it works with backticks, thanks I haven't known that. – Maaaaa Dec 06 '17 at 18:29